Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key joins revisited - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Foreign key joins revisited
Date
Msg-id CAKFQuwbJhyW6xTUeZH+2c9eSD34ugwUoJCBQsC4fB9fP-bFzWA@mail.gmail.com
Whole thread Raw
In response to Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: Foreign key joins revisited  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
Tree view
On Saturday, December 25, 2021, Joel Jacobson <joel@compiler.org> wrote:

I've revisited the idea to somehow use foreign keys to do joins,


-1
 
This is somewhat addressed by the USING join form, but USING has other drawbacks, why I tend to avoid it except for one-off queries.

I find this sufficient.

 
* Would require changes to the SQL standard, i.e. SQL committee work

Huh?

David J.

pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Foreign key joins revisited
Next
From: "Joel Jacobson"
Date:
Subject: Re: Foreign key joins revisited