Select + min question

Hi,

I have created a table like this:

CREATE TABLE test (
        b_date char(8),
        active boolean,
        id serial
);

and inserted some rows.

Now,  what I want is to select the b_date which has the minimum "id" and 
active=t.

A normal query would be : 
        SELECT b_date,min(id) FROM test WHERE active='t' GROUP BY id LIMIT 1

However, I only want to select b_date. So, if I perform the following 
query, I get the following error:

devrim=# SELECT b_date FROM test WHERE active='t' AND id=min(id) LIMIT 1;
ERROR:  Aggregates not allowed in WHERE clause

What should I do? ANy suggestions?

Best regards.
-- 

Devrim GUNDUZ

devrim@xxxxxxxxxxxxxxxx
devrim.gunduz@xxxxxxxxxxxx

Web : http://devrim.oper.metu.edu.tr
-------------------------------------





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster