By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Automatic joins?

P: n/a
I tried posting this before, but I don't think it got posted. Sorry if
it did.

According to the Wikipedia article on PostgreSQL
(, it has a feature for
automatic joins:

"SELECT u.* FROM user u, address a WHERE'New York' and

In Postgres the relationship between users and addresses can be
explicity defined. Once defined the address becomes a property of the
user, so the search above can be simplified greatly to:

SELECT * FROM user WHERE'New York'"

Is the a load of nonsense, or am I doing something wrong? I did define a
foreign key, but it doesn't work.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

Nov 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.