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

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: 2008-09-19 22:02:25
Message-ID: 20080919150225.383a35f3@jd-laptop (view raw or flat)
Thread:
Lists: pdxpug
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



In response to

pdxpug by date

Next:From: jterwillDate: 2008-09-19 22:55:36
Subject: Re: 9/18 Visual Planner Meeting Wrapup
Previous:From: Mark WongDate: 2008-09-19 21:53:15
Subject: 9/18 Visual Planner Meeting Wrapup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group