Paolo Saul <paolo.saul@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general