Thread: Min and Max aggregates.

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.

> ... 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)