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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
