Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: 9/18 Visual Planner Meeting Wrapup


  • From: Joshua Drake <jd(at)commandprompt(dot)com>
  • To: "Mark Wong" <markwkm(at)gmail(dot)com>
  • Cc: "Postgresql PDX_Users" <pdxpug(at)postgresql(dot)org>
  • Subject: Re: 9/18 Visual Planner Meeting Wrapup
  • Date: Fri, 19 Sep 2008 15:02:25 -0700
  • Message-id: <20080919150225.383a35f3@jd-laptop> <text/plain>

On Fri, 19 Sep 2008 14:53:15 -0700
"Mark Wong" <markwkm(at)gmail(dot)com> wrote:

> Can anyone come up with an example of a meaningful query where there
> is a join that does not use an implicit or explicit foreign key?

Only partial. A LEFT or RIGHT JOIN will do this but it needs a partial
key to work.

So: No.

Sincerely,

Joshua D. Drake


-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group