Ilya,

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html