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