On Mon, Jun 29, 2009 at 2:08 PM, littlesuspenselittlesuspe...@web.de 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
-Ursprüngliche Nachricht-
Von: Scott Marlowe scott.marl...@gmail.com
Gesendet: 30.06.09 10:17:11
An: Waldemar Bergstreiser littlesuspe...@web.de
CC: pgsql-general@postgresql.org
Betreff: Re: [GENERAL]
On Tue, Jun 30, 2009 at 2:00 AM, Waldemar
Bergstreiserlittlesuspe...@web.de
-- 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, you don't get it. Probably so