Skip site navigation (1) Skip section navigation (2)

Re: wikipedia article

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Ilya S(dot) Slyzhnyak" <ilya(at)odt(dot)east(dot)telecom(dot)kz>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: wikipedia article
Date: 2004-06-07 20:10:04
Message-ID: 200406071310.04634.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Robert MorganDate: 2004-06-08 00:36:33
Subject: selecting tables and columns
Previous:From: Josh BerkusDate: 2004-06-07 20:03:47
Subject: Re: Ignoring an SQL INSERT error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group