Thread: outer joins

So, is there an eloquent (or not) way to fake an outer join in PostgreSQL?

Ken

Hello,

At 19.00 07/03/99 -0800, you wrote:
>So, is there an eloquent (or not) way to fake an outer join in PostgreSQL?

yes! Example of a workaround using unions:

select
    X.a, X.b,
    Y.a, Y.b
from
    X left outer join Y on X.a = Y.a

becomes

select
    X.a, X.b,
    Y.a, Y.b
from
    X,Y
where
    X.a = Y.a
union
select
    X.a, X.b,
    null, null
from
    X
where
    not exists (select * from Y where Y.a = X.a)

Little cumbersome but it works.

Bye!

    Sbragion Denis
    InfoTecna
    Tel, Fax: +39 039 2324054
    URL: http://space.tin.it/internet/dsbragio