Re: [HACKERS] calculated fields are not seen in the WHERE clause

[Bruce Momjian]

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

Re: [HACKERS] calculated fields are not seen in the WHERE clause

[Hannu Krosing]

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]

[HACKERS] calculated fields are not seen in the WHERE clause

[Yaroslav Dmitriev]

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



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly