Unix Technical Forum

Shouldn't Natural JOINs Follow FK Constraints?

This is a discussion on Shouldn't Natural JOINs Follow FK Constraints? within the pgsql Hackers forums, part of the PostgreSQL category; --> Howdy, I just saw this in the docs: > Finally, NATURAL is a shorthand form of USING: it forms ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-02-2008, 12:36 PM
David E. Wheeler
 
Posts: n/a
Default Shouldn't Natural JOINs Follow FK Constraints?

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 named my columns exactly the
same between the two tables, but couldn't a NATURAL JOIN follow the FK
constraints, instead? That would be so much more useful and much less
magical, I should think.

Thanks,

David

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:14 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com