Re: How do I disable: Adding missing FROM-clause - Mailing list pgsql-general

From Tom Lane
Subject Re: How do I disable: Adding missing FROM-clause
Date
Msg-id 21153.1096034539@sss.pgh.pa.us
Whole thread Raw
In response to Re: How do I disable: Adding missing FROM-clause  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Fri, Sep 24, 2004 at 10:41:04AM +0200, Sebastian B=F6ck wrote:
>> Thought about this when reading
>> http://en.wikipedia.org/wiki/PostgreSQL
>> |
>> | PostgreSQL can explicitly define the relationship between users
>> | and addresses. Once defined, the address becomes a property of
>> | the user, so the search can be greatly simplified to:
>> | SELECT * FROM user WHERE address.city='New York'

> I'm pretty sure this is wrong. I've never seen anything in PostgreSQL
> that might do what that bit says.

It's possible that this is an accurate description of something that
would work back in the PostQUEL days.  It's certainly bogus now, though.
Anyone want to go fix it?

            regards, tom lane

pgsql-general by date:

Previous
From: "Net Virtual Mailing Lists"
Date:
Subject: Postgres inherited table, some questions...
Next
From: Tom Lane
Date:
Subject: Re: need ``row number``