On Fri, Sep 24, 2004 at 10:41:04AM +0200, Sebastian Böck wrote:
> Thought about this when reading
> http://en.wikipedia.org/wiki/PostgreSQL
>
> This site says:
> | A typical search might look like this:
> |
> | SELECT u.* FROM user u, address a WHERE a.city='New York'
> | AND a.user_name=u.user_name
> |
> | 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'
>
> This example isn't working for me "as it is".
> What relationships have to be defined and how?
> Normal foreign keys aren't working.
I'm pretty sure this is wrong. I've never seen anything in PostgreSQL
that might do what that bit says. There are some other inaccuracies too
I think.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.