2012/4/6 Rob Sargent <[email protected]>: > On 04/06/2012 01:23 PM, Pavel Stehule wrote: >> >> Hello >> >> 2012/4/6 Andreas<[email protected]>: >>> >>> 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 ([email protected]) >>> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
