Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 4F2251BFF91C
	for <pgsql-sql@postgresql.org>; Fri,  6 Apr 2012 16:27:03 -0300 (ADT)
Received: from mail-pb0-f46.google.com ([209.85.160.46])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <robjsargent@gmail.com>) id 1SGEoH-0007uU-N5
	for pgsql-sql@postgresql.org; Fri, 06 Apr 2012 19:27:02 +0000
Received: by pbcun15 with SMTP id un15so2916018pbc.19
	for <pgsql-sql@postgresql.org>; Fri, 06 Apr 2012 12:26:48 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	bh=s2xaxfJqehidwNRi9bvbSXjrHi+GDN16V3WOoIVSXjY=;
	b=LywI78B1Fz6tVxYX6iw14+wAiRZqWW6CmdQcn4hdAwZtJyonJjM06emwagiRZgknAk
	AP6ZUxY45s7Jt44z8/uPlUFD5ncv4Uj4GwOobE8cyLL58/dAdKF7dkQZqbCxq0dXJXIF
	4kM4euAP68+bzrVQ9tJoGeziqqf98fffzRn88lSvr1GNqUx11aq4FzQ6yPaHXLUeO8PD
	/TYOwV9bVO878bs3G8rrM7lfxahoIECCSwC8XVXtuAjJlG7HePfMomje0yhu8tV3RExm
	GE0/vrU3swxPWbVctdYwHMjiMJvIFY4dhlGbvQ5aIKKoc4LCEA9win8cy2mdQzK0Itz8
	vexQ==
Received: by 10.68.216.3 with SMTP id om3mr18037015pbc.18.1333740408868;
	Fri, 06 Apr 2012 12:26:48 -0700 (PDT)
Received: from [172.16.1.88] ([208.187.158.94])
	by mx.google.com with ESMTPS id g4sm7017931pbt.58.2012.04.06.12.26.46
	(version=SSLv3 cipher=OTHER); Fri, 06 Apr 2012 12:26:47 -0700 (PDT)
Message-ID: <4F7F43C8.4010204@gmail.com>
Date: Fri, 06 Apr 2012 13:28:08 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:11.0) Gecko/20120329 Thunderbird/11.0.1
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: syntax of joins
References: <4F7F3CD9.9090103@gmx.net>
	<CAFj8pRBc2Qa+_Zap_8VqOQzjaYWXtkajjhKePKs9pYGnkcoX+w@mail.gmail.com>
In-Reply-To: 
 <CAFj8pRBc2Qa+_Zap_8VqOQzjaYWXtkajjhKePKs9pYGnkcoX+w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201204/17
X-Sequence-Number: 36494

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"