Request a Demo
Home   >   mailing lists

Re: nested inner join help - Mailing list pgsql-sql

From Tom Lane
Subject Re: nested inner join help
Date
Msg-id 20144.1011050737@sss.pgh.pa.us
Whole thread Raw
In response to Re: nested inner join help  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: nested inner join help
List pgsql-sql
Tree view 
"Josh Berkus" <josh@agliodbs.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

pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Result sets from functions
Next
From: Stephan Szabo
Date:
Subject: Re: On delete cascade!