From: Emils <gnudiff@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Outer joins
Date: Sat, 29 Apr 2006 11:33:00 +0300
Message-ID: <9dcb6fa40604290133l47b67930n@mail.gmail.com> (raw)
(damn gmail, sorry about priv mail earlier)
> Stephan Szabo <sszabo@megazone.bigpanda.com>:
> I think putting a test in an ON clause associated with the join (using
> something like ... left join object_values ov1 ON(ov.obj_id = ov1.obj_id
> and ov1.att_id=8) rather than where will consider both as part of the join
> and null extend even if there are obj_id matches if none of those have
> att_id=8.
Thanks, that worked!
2006/4/28, Tom Lane <tgl@sss.pgh.pa.us>:
> Emils <gnudiff@gmail.com> writes:
> > The table structure is:
>
> > object_values
> > ==========
> This isn't an outer-join problem, it's a crosstab problem. Try the
> crosstab functions in contrib/tablefunc.
>
Thanks, I looked into it, unfortunately I might have to have also a
solution for where installing contrib stuff is not possible.
Emils
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: gnudiff@gmail.com
Subject: Re: Outer joins
In-Reply-To: <9dcb6fa40604290133l47b67930n@mail.gmail.com>
* 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