AS strings are labels, not columns that can be referenced in a where
clause:
test=> select lanname as xx from pg_language where xx = 'yy';
Hannu is correct that making a FROM entry works.
---------------------------------------------------------------------------
Hannu Krosing wrote:
> 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]
>
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
