Hello
2012/4/6 Andreas <maps(dot)on(at)gmx(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql