Received: from golem.jpl.nasa.gov (IDENT:root@hectic-3.jpl.nasa.gov [128.149.68.205]) by hub.org (8.9.1/8.9.1) with ESMTP id AAA29159 for ; Thu, 10 Dec 1998 00:35:49 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost [127.0.0.1]) by golem.jpl.nasa.gov (8.8.5/8.8.5) with ESMTP id FAA04804; Thu, 10 Dec 1998 05:35:31 GMT Sender: tgl@mythos.jpl.nasa.gov Message-ID: <366F5DA3.471929A6@alumni.caltech.edu> Date: Thu, 10 Dec 1998 05:35:31 +0000 From: "Thomas G. Lockhart" Organization: Caltech/JPL X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.30 i686) MIME-Version: 1.0 To: John Bosch CC: pgsql-interfaces Subject: Re: [INTERFACES] Min and Max aggregates. References: <366F4639.AA900B60@john.cdscc.nasa.gov> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > ... the min and max aggregate functions return 0 > if more than one row happens to have the same value in the tested > column and that value also happens to be the minimum or maximum? I've not noticed it, and can't reproduce it with a small test case on my machine. Will need more details to be able to help... Cheers. - Tom postgres=> select min(i) from b; min --- 1 (1 row) postgres=> select * from b; i| k -+-- 1|-1 2|-2 3|-3 2| 4 1| 5 (5 rows)