calculated fields are not seen in the WHERE clause

From: "Yaroslav Dmitriev" <yar(at)warlock(dot)ru>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: calculated fields are not seen in the WHERE clause
Date: 2002-10-30 11:48:19
Message-ID: 37616.194.85.240.205.1035978499.squirrel@www.snow.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-10-30 12:03:25 Re: calculated fields are not seen in the WHERE clause
Previous Message Pedro Miguel Frazao Fernandes Ferreira 2002-10-30 10:35:09 Re: float output precision questions