salah jubeh <s_jubeh@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general