Postgres Pro
Downloads
Home   >   mailing lists

Re: correlated query as a column and where clause - Mailing list pgsql-general

From Tom Lane
Subject Re: correlated query as a column and where clause
Date
Msg-id 24748.1302882575@sss.pgh.pa.us
Whole thread Raw
In response to Re: correlated query as a column and where clause  (salah jubeh <s_jubeh@yahoo.com>)
Responses Re: correlated query as a column and where clause
List pgsql-general
Tree view 
salah jubeh <s_jubeh@yahoo.com> writes:
> But, why I can not  use the alias of the select statement ( as in the original
> post)  in the where clause.

The select list can only be computed after the where clause has filtered
the rows, so such a thing would be circular.

            regards, tom lane

pgsql-general by date:

Previous
From: salah jubeh
Date:
Subject: Re: correlated query as a column and where clause
Next
From: Paul Millar
Date:
Subject: How to silence constraint violation logging for an INSERT