> 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
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;
Aglio Database Solutions
In response to
pgsql-novice by date
|Next:||From: Robert Morgan||Date: 2004-06-08 00:36:33|
|Subject: selecting tables and columns|
|Previous:||From: Josh Berkus||Date: 2004-06-07 20:03:47|
|Subject: Re: Ignoring an SQL INSERT error|