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(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr

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