It is a query that looks like
SELECT target1, target2... targetn, SUN(t.qty)
FROM Table t
GROUP BY target1
HAVING SUM(t.qty)>=10
You can replace SUM(t.qty)>=10 with other aggregate constraints.
----- Original Message -----
From: Christoph Haller
To: pgsql-sql(at)postgresql(dot)org
Cc: wweng(at)kencast(dot)com
Sent: Tuesday, February 04, 2003 3:39 AM
Subject: Re: [SQL] iceberg queries
>
> Does PostgreSQL optimizer handle iceberg queries well?
>
What do you mean by "iceberg query" ?
I've never heard this term.
Regards, Christoph