Postgres Pro
Downloads
Home   >   mailing lists

calculated fields are not seen in the WHERE clause - Mailing list pgsql-hackers

From Yaroslav Dmitriev
Subject calculated fields are not seen in the WHERE clause
Date
Msg-id 37616.194.85.240.205.1035978499.squirrel@www.snow.ru
Whole thread Raw
Responses Re: calculated fields are not seen in the WHERE clause  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Tree view 
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?

Best regards,
Yar

pgsql-hackers by date:

Previous
From: Pedro Miguel Frazao Fernandes Ferreira
Date:
Subject: Re: float output precision questions
Next
From: Dave Prosser
Date:
Subject: Re: [Fwd: Re: UnixWare 7.1.3 (BETA), C99 compiler,