Re:

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: littlesuspense <littlesuspense(at)web(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2009-06-29 21:11:17
Message-ID: dcc563d10906291411t7c695284p9d79e775d82cc3bc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense<littlesuspense(at)web(dot)de> wrote:
> 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:

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 just called joins.

> select * from a, outer b where a.id = b.id;

select * from a full join b on (a.id=b.id) where ...
select * from a left join b on (a.id=b.id) where ...
select * from a join b on (a.id=b.id) where ...

and so on.

> And surely, I would like to see that also in postgresql.

What you get with postgresql is mostly ANSI standard stuff, which
left/right/full outer and inner joins are.

In response to

  • at 2009-06-29 20:08:59 from littlesuspense

Responses

  • Re: at 2009-06-29 21:23:00 from Merlin Moncure

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-06-29 21:23:00 Re:
Previous Message littlesuspense 2009-06-29 20:08:59