Re: [SQL] How change col name during query to use it in where clause

[Thomas Kellerer]

Marcel Ruff, 04.05.2012 12:25:

Hi,

is an alias name not usable in the where clause?

select EXTRACT(day from enddate::TIMESTAMP - old_enddate::TIMESTAMP) AS TAGE from 
account_h where TAGE>5;
ERROR: column "tage" does not exist
LINE 1: ... TAGE>5 ...

You need to wrap the query:

select *
from (
   select EXTRACT(day from enddate::TIMESTAMP - old_enddate::TIMESTAMP) AS TAGE
   from account_h
) t
where TAGE > 5;




--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql