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 :)
-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
