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) sub
 where ccc=1

---------------
Hannu


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to