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  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: How change col name during query to use it in where clause  (Thomas Kellerer <spam_eater@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Robert Bernier
Дата:
Сообщение: Re: [seapug] Re: [BUGS] pg_dump: aborting because of server version mismatchT
Следующее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: How change col name during query to use it in where clause