Re: [INTERFACES] Min and Max aggregates. - Mailing list pgsql-interfaces

From Thomas G. Lockhart
Subject Re: [INTERFACES] Min and Max aggregates.
Date
Msg-id 366F5DA3.471929A6@alumni.caltech.edu
Whole thread Raw
In response to Min and Max aggregates.  (John Bosch <jbosch@john.cdscc.nasa.gov>)
List pgsql-interfaces
> ... 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)

pgsql-interfaces by date:

Previous
From: John Bosch
Date:
Subject: Min and Max aggregates.
Next
From: Sergio Kessler
Date:
Subject: Re: [INTERFACES] bug in ODBC driver ?