On Wed, Dec 11, 2002 at 11:26:20AM -0500, Wei Weng wrote:
> I don't think there is any. It is just another way to write an outer
> join.
That's not exactly true. Doing A JOIN B ON (A.ID=B.ID) constrains
the planner. See the section on explicit join order in the
PostgreSQL manual.
The IN locution, by the way, is almost always bad in Postgres. Avoid
it.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110