Re: iceberg queries

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@postgresql.org 
Cc: wweng@kencast.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