Re: Outer joins - Mailing list pgsql-sql

(damn gmail, sorry about priv mail earlier)

> Stephan Szabo <[email protected]>:
> 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 <[email protected]>:
> Emils <[email protected]> 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