Re: syntax of joins

On 04/06/2012 01:23 PM, Pavel Stehule wrote:
> Hello
>
> 2012/4/6 Andreas<maps(dot)on(at)gmx(dot)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(at)postgresql(dot)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"