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

2002-11-01 Thread 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

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

2002-10-30 Thread 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

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

2002-10-30 Thread 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]