How change col name during query to use it in where clause

Поиск
Список
Период
Сортировка
От Marcel Ruff
Тема How change col name during query to use it in where clause
Дата
Msg-id 4FA3AEA9.6010401@marcelruff.info
обсуждение исходный текст
Ответы Re: How change col name during query to use it in where clause
Re: How change col name during query to use it in where clause
Список pgsql-sql
Дерево обсуждения 
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 ...

Thank you
Marcel

В списке pgsql-sql по дате отправления: