Re: iceberg queries - Mailing list pgsql-sql

From Wei Weng
Subject Re: iceberg queries
Date
Msg-id 002101c2cc56$f5112330$2f437242@PASCAL
Whole thread Raw
In response to Re: iceberg queries  (Christoph Haller <ch@rodos.fzk.de>)
Responses Re: iceberg queries
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SQL99/SQL92 Grammar
Next
From: Bruno Wolff III
Date:
Subject: Re: iceberg queries