2012/4/6 Rob Sargent <robjsarg...@gmail.com>: > On 04/06/2012 01:23 PM, Pavel Stehule wrote: >> >> Hello >> >> 2012/4/6 Andreas<maps...@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 :) >
Hard to say - for man who fixed critical cartesian products :) in queries Pavel > -some cranky old guy who still misses "retrieve" > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
