Hi Volk, at first sorry for my English. I use postgresql very often and I really love it but the syntax for outer join make me sick. Oracle short notation (+) is also not a best choice at this place but I recall me, that the Informix have a really good and clear syntax:
select * from a, outer b where a.id = b.id; select * from a, outer( b, outer c) where a.id = b.id and b.id= c.id; And surely, I would like to see that also in postgresql. I hope, I can win you for that. Sincerely, LS