Postgres column does not exist but it's there with alias [duplicate] Postgres column does not exist but it's there with alias [duplicate] postgresql postgresql

Postgres column does not exist but it's there with alias [duplicate]


I found the explanation here: http://www.postgresql.org/message-id/18195.1038530280@sss.pgh.pa.us

I can't use the alias from the select in the WHERE clause.