X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D9812474E44
	for <pgsql-sql@postgresql.org>; Tue,  4 Feb 2003 09:10:14 -0500 (EST)
Received: from mail1.acecape.com (mail1.acecape.com [66.114.74.12])
	by postgresql.org (Postfix) with ESMTP id 379EC474E42
	for <pgsql-sql@postgresql.org>; Tue,  4 Feb 2003 09:10:14 -0500 (EST)
Received: from PASCAL (p67-47.acedsl.com [66.114.67.47])
	by mail1.acecape.com (8.12.2/8.12.2) with SMTP id h14EAHGX008840;
	Tue, 4 Feb 2003 09:10:17 -0500
Message-ID: <002101c2cc56$f5112330$2f437242@PASCAL>
From: "Wei Weng" <wweng@kencast.com>
To: "Christoph Haller" <ch@rodos.fzk.de>, <pgsql-sql@postgresql.org>
References: <3E3F7C59.E6C5278C@rodos.fzk.de>
Subject: Re: iceberg queries
Date: Tue, 4 Feb 2003 09:08:56 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/76
X-Sequence-Number: 11474

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