Re: simple join problem - Mailing list pgsql-sql

From Matthew Nuzum
Subject Re: simple join problem
Date
Msg-id 004001c2d85c$05d214c0$6900a8c0@mattspc
Whole thread Raw
In response to Re: simple join problem  (Josh Berkus <josh@agliodbs.com>)
Responses Re: simple join problem
List pgsql-sql
> >
> > Here's my view definition:
> > SELECT
> >     users.uid, users.loginid, users."password", users.title,
> >     users.firstname, users.middlename, users.lastname, users.suffix,
> >     users.organization, users.job_title, users_address.address1,
> >     users_address.address2, users_address.address3, users_address.city,
> >      users_address.state, users_address.zip, users_address.country,
> >     users_email.email, users_phone.phone
> > FROM (((users
> >     LEFT JOIN users_address ON ((users.uid = users_address.uid AND
> users_address.primary = TRUE)))
> >     LEFT JOIN users_email ON ((users.uid = users_email.uid and
> users_email.primary = TRUE)))
> >     LEFT JOIN users_phone ON ((users.uid = users_phone.uid and
> users_phone.primary = TRUE))) ;
> 
> It's a neat trick that join conditions can be *any* expression that
> evaluates
> to a boolean value.

That is a neat trick.  Thanks for the info everyone.  I feel better knowing
that even though it was a simple problem it's not quite as obvious as I
thought.

--
Matthew Nuzum
www.bearfruit.org
cobalt@bearfruit.org




pgsql-sql by date:

Previous
From: JBJ
Date:
Subject: Re: once again, sorting with Unicode
Next
From: Josh Berkus
Date:
Subject: Re: PL/PGSQL EDITOR