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)