Re: Foreign key joins revisited

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Joel Jacobson <joel(at)compiler(dot)org>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Foreign key joins revisited
Date: 2021-12-25 21:06:44
Message-ID: CAKFQuwbJhyW6xTUeZH+2c9eSD34ugwUoJCBQsC4fB9fP-bFzWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Saturday, December 25, 2021, Joel Jacobson <joel(at)compiler(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Jacobson 2021-12-25 21:19:13 Re: Foreign key joins revisited
Previous Message Joel Jacobson 2021-12-25 20:55:51 Foreign key joins revisited