Min and Max aggregates.

From: John Bosch <jbosch(at)john(dot)cdscc(dot)nasa(dot)gov>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Min and Max aggregates.
Date: 1998-12-10 03:55:37
Message-ID: 366F4639.AA900B60@john.cdscc.nasa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


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(at)john(dot)cdscc(dot)nasa(dot)gov

I doubt, therefore I might be.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-12-10 05:35:31 Re: [INTERFACES] Min and Max aggregates.
Previous Message Michael Yeung 1998-12-10 00:32:19 Lock the server