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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Web : http://devrim.oper.metu.edu.tr
-------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
