Обсуждение: Re: Outer joins

Поиск
Список
Период
Сортировка

Re: Outer joins

От
Emils
Дата:
(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