Subject: How do you write this query?
From: Wei Weng <wweng@kencast.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 31 Oct 2002 13:21:25 -0500
Message-Id: <1036088486.13986.19.camel@Monet>
Mime-Version: 1.0

I have a table 

                 Table "test"
Column	|            Type        | Modifiers
--------+------------------------+----------
data    | integer                | not null 
data1   | character varying(128) | not null
data2   | character varying(128) | not null

(Note: data is NOT the primary key.)

And 
select * from test 
returns


 data | data1 | data2 
------+-------+-------
    1 | foo   | bar 
    2 | greg  | bar
    3 | pooh  | bar
    4 | dah   | peng

I need a query that returns me the "data1" that satisfies the logic of
the following pseudo code:

1: select data2 into @out from test where data1 = 'pooh'
2: select data1 from test where data2 = @out and data = 3


What do I do?

Thanks!

-- 
Wei Weng
Network Software Engineer
KenCast Inc.