There is an FAQ item about it.
> why it is a problem at all, if you use sql so long? outer join
> can be easily simulated.
>
> On Tue, 18 Apr 2000, Michael S. Kelly wrote:
>
> > I understand that outer joins are not supported in PostgreSQL. I'm just
> > starting my first PostgreSQL project, and have to admit that this concerns
> > me. Outer joins have come in handy, at some point, in almost every database
> > project I've ever worked on. I guess I'd like to hear how you all work
> > around this issue.
> >
> > Thanks,
> >
> > -=michael=-
> >
>
>
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026