| From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Reg Me Please" <regmeplease(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: NATURAL JOINs |
| Date: | 2008-10-15 16:17:27 |
| Message-ID: | 396486430810150917j4b9a06a0l3970fe192fc99464@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 15, 2008 at 9:03 AM, Reg Me Please <regmeplease(at)gmail(dot)com> wrote:
> Both are perfectly right, indeed.
> Nonetheless, in my opinion a NATURAL JOIN exploiting the FKs
> instead of the column names would be much more helpful and much less error
> prone!
>
> As far as I know there is no way to exploit FKs in JOINs, right?
Yes AFAIK, this would make postgresql's implementation of natural join
violate the SQL standard. Perhaps you could propose an "UNNATURAL
JOIN" syntax extension. ;)
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-15 16:17:35 | Re: Column level triggers |
| Previous Message | Tom Lane | 2008-10-15 16:13:03 | Re: Drupal and PostgreSQL - performance issues? |