From: Matthew Nuzum <cobalt@bearfruit.org>
To: josh@agliodbs.com
To: 'Matthew Nuzum' <cobalt@bearfruit.org>
To: pgsql-sql@postgresql.org
Subject: Re: simple join problem
Date: Wed, 19 Feb 2003 16:15:25 -0500
Message-ID: <004001c2d85c$05d214c0$6900a8c0@mattspc> (raw)
In-Reply-To: <200302191249.26342.josh@agliodbs.com>
> >
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cobalt@bearfruit.org, josh@agliodbs.com
Subject: Re: simple join problem
In-Reply-To: <004001c2d85c$05d214c0$6900a8c0@mattspc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox