Re: nested inner join help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: "Darryl M(dot) Wolski" <drwolski(at)sympatico(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: Re: nested inner join help
Date: 2002-01-14 23:25:37
Message-ID: 20144.1011050737@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Josh Berkus" <josh(at)agliodbs(dot)com> writes:
> One significant MSAccess <==> Postgres conflict is that Postgres assumes that
> parens in the FROM clause represent subselects (I think),

Huh? Parenthesizing JOINs is perfectly valid, and I think it's good
style too in complex cases. See the nearby "SQL Joins" thread for
an example of a query that's quite unreadable without 'em.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-01-14 23:53:10 Re: On delete cascade!
Previous Message Jochem van Dieten 2002-01-14 22:47:37 Re: Long-running DELETE...WHERE...