salah jubeh <s_ju...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general