Re: calculated fields are not seen in the WHERE clause

Поиск
Список
Период
Сортировка
Искать
От
Hannu Krosing
Тема
Re: calculated fields are not seen in the WHERE clause
Дата
Msg-id
1035979405.3843.23.camel@taru.tm.ee
Ответ на
calculated fields are not seen in the WHERE clause (Yaroslav Dmitriev)
Список
Дерево обсуждения
calculated fields are not seen in the WHERE clause "Yaroslav Dmitriev" <yar@warlock.ru>
Re: calculated fields are not seen in the WHERE clause Hannu Krosing <hannu@tm.ee>
Re: calculated fields are not seen in the WHERE clause Bruce Momjian <pgman@candle.pha.pa.us> 
Yaroslav Dmitriev kirjutas K, 30.10.2002 kell 13:48:
> Hello,
> 
> OK
> select 1 as ccc where 1=1
> 
> ERROR
> select 1 as ccc where ccc=1
> PostgreSQL said: ERROR: Attribute 'ccc' not found
> 
> Is there any way to set conditions on calculated fields values?

You could try using a subquery

select *from(select 1 as ccc) subwhere ccc=1

---------------
Hannu
В списке pgsql-hackers по дате отправления
Предыдущее
От: Greg Patnude
Дата:
Следующее
От: Robert Treat
Дата:
FAQ