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]