> On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense wrote:
> > Hi Volk,
> >
> Note that the word outer is just noise in pgsql, i.e. it's not needed.
> What you've got are left outer, right outer, and full outer joins.
> All can be called just left, right, or full joins. Note that inner
> joins are
> -Ursprüngliche Nachricht-
> Von: "Scott Marlowe"
> Gesendet: 30.06.09 10:17:11
> An: Waldemar Bergstreiser
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL]
> On Tue, Jun 30, 2009 at 2:00 AM, Waldemar
> Bergstreiser wrote:
&g
> >> > -- c *= b *= a =* d =* f
> >> > select * from a, outer( b, outer c), outer (d, outer f )
> >> > where a.b_id = b.id and b.c_id = c.id and a.d_id = d.id and d.f_id =
> >> > f.id;
> >>
> >> from a full join b on (a.id=b.id)
> >> full join c on (b.id=c.id)
> >> full join d
> >>
> >
> > I guess
