Postgres Pro
Downloads
Home   >   mailing lists

Re: Is this a bug or a feature? Column visibility in subquery from outer query - Mailing list pgsql-general

From Tom Lane
Subject Re: Is this a bug or a feature? Column visibility in subquery from outer query
Date
Msg-id 29685.1242656877@sss.pgh.pa.us
Whole thread Raw
In response to Is this a bug or a feature? Column visibility in subquery from outer query  (Paolo Saul <paolo.saul@telogis.com>)
Responses Re: Is this a bug or a feature? Column visibility in subquery from outer query  (Paolo Saul <paolo.saul@telogis.com>)
List pgsql-general
Tree view 
Paolo Saul <paolo.saul@telogis.com> writes:
> I just want to point out that the sub-query is using a column from the outer
> query (eg. x1)  without an alias from the table in the outer query.

This behavior is required by the SQL standard.  It's called an outer
reference.

            regards, tom lane

pgsql-general by date:

Previous
From: Scara Maccai
Date:
Subject: referring to calculated column in sub select
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump and 2gb limit on windows and version 8.1.3