syntax of joins

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: syntax of joins
Date: 2012-04-06 18:58:33
Message-ID: 4F7F3CD9.9090103@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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;

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2012-04-06 19:23:32 Re: syntax of joins
Previous Message Julien Cigar 2012-04-05 14:29:32 Re: bad plan