Re: wikipedia article

Ilya,

> Here is an article at wikipedia (http://en.wikipedia.org/wiki/PostgreSQL)
> And here is a question: how relation between tables user and address have
> to be declared?

Regrettably, the Wikipedia article is incorrect. It might be nice to have
such a feature, but we don't actually have it. I'm not sure where they got
their information from.

The inaccuracies in the Wikipedia article have already been raised in the
PGSQL-DOCS mailing list, and I believe (hope) that someone is working to
correct them.

You should query the user and address table in the normal way, i.e.

SELECT users.* FROM users JOIN addresses ON users.address = addresses.id;

--
Josh Berkus
Aglio Database Solutions
San Francisco