[HACKERS] Shouldn't Natural JOINs Follow FK Constraints?

2008-05-30 Thread David E. Wheeler
Howdy, I just saw this in the docs: Finally, NATURAL is a shorthand form of USING: it forms a USING list consisting of exactly those column names that appear in both input tables. As with USING, these columns appear only once in the output table. That sounds useful if I happen to have

Re: [HACKERS] Shouldn't Natural JOINs Follow FK Constraints?

2008-05-30 Thread Jeff Davis
On Fri, 2008-05-30 at 13:19 -0700, David E. Wheeler wrote: Howdy, I just saw this in the docs: Finally, NATURAL is a shorthand form of USING: it forms a USING list consisting of exactly those column names that appear in both input tables. As with USING, these columns appear only

[HACKERS] Shouldn't Natural JOINs Follow FK Constraints?

2008-05-30 Thread David E . Wheeler
Howdy, I just saw this in the docs: Finally, NATURAL is a shorthand form of USING: it forms a USING list consisting of exactly those column names that appear in both input tables. As with USING, these columns appear only once in the output table. That sounds useful if I happen to have