Re: syntax of joins

On 04/06/2012 01:23 PM, Pavel Stehule wrote:
> Hello
>
> 2012/4/6 Andreas<maps.on@gmx.net>:
>> hi,
>>
>> is there a disadvantage to write a join as
>>
>> select   *
>> from    a, b
>> where  a.id = b.a_id;
>>
>
>> over
>>
>> select   *
>> from    a join b  on  a.id = b.a_id;
>>
>
> yes - newer notation has some advantages
>
> * clean specification join predicate and filter predicate
> * simple adaptability to outer join
> * increased protection against copy/paste bug that introduce Cartesian product
>
> Regards
>
> Pavel Stehule
>
>> --
>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-sql
>
In other words, no disadvantage :)

-some cranky old guy who still misses "retrieve"