| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Sebastian Böck <sebastianboeck(at)freenet(dot)de>, terry(at)ashtonwoodshomes(dot)com, "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How do I disable: Adding missing FROM-clause |
| Date: | 2004-09-24 14:02:19 |
| Message-ID: | 21153.1096034539@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martijn van Oosterhout <kleptog(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-24 14:20:13 | Re: need ``row number`` |
| Previous Message | Najib Abi Fadel | 2004-09-24 13:59:11 | Re: plpgsql-fct. fails on NULL in record variables |