From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: syntax of joins
Date: Fri, 06 Apr 2012 13:28:08 -0600
Message-ID: <4F7F43C8.4010204@gmail.com> (raw)
In-Reply-To: <CAFj8pRBc2Qa+_Zap_8VqOQzjaYWXtkajjhKePKs9pYGnkcoX+w@mail.gmail.com>
References: <4F7F3CD9.9090103@gmx.net>
<CAFj8pRBc2Qa+_Zap_8VqOQzjaYWXtkajjhKePKs9pYGnkcoX+w@mail.gmail.com>
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com
Subject: Re: syntax of joins
In-Reply-To: <4F7F43C8.4010204@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox