Received: from john. (john.cdscc.nasa.gov [192.195.197.12])
	by hub.org (8.9.1/8.9.1) with SMTP id WAA20307
	for <pgsql-interfaces@postgresql.org>;
	Wed, 9 Dec 1998 22:56:16 -0500 (EST)
	(envelope-from jbosch@john.cdscc.nasa.gov)
Received: from john.cdscc.nasa.gov by john. (SMI-8.6/SMI-SVR4)
	id OAA01192; Thu, 10 Dec 1998 14:55:37 +1100
Sender: jbosch@john
Message-ID: <366F4639.AA900B60@john.cdscc.nasa.gov>
Date: Thu, 10 Dec 1998 14:55:37 +1100
From: John Bosch <jbosch@john.cdscc.nasa.gov>
Organization: Canberra Deep Space Communications Complex
X-Mailer: Mozilla 4.06 [en] (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Min and Max aggregates.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Has anybody else noted that 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?

This is really messing with what I want to do!

--
regards,

John Bosch
Systems Engineer
Canberra Deep Space Communications Complex
jbosch@john.cdscc.nasa.gov

I doubt, therefore I might be.