Re: Outer joins

(damn gmail, sorry about priv mail earlier)

> Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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(at)sss(dot)pgh(dot)pa(dot)us>:
> Emils <gnudiff(at)gmail(dot)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