pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedMin and Max aggregates.
2+ messages / 2 participants
[nested] [flat]
* Min and Max aggregates.
@ 1998-12-10 03:55 John Bosch <jbosch@john.cdscc.nasa.gov>
0 siblings, 1 reply; 2+ messages in thread
From: John Bosch @ 1998-12-10 03:55 UTC (permalink / raw)
To: 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@john.cdscc.nasa.gov
I doubt, therefore I might be.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Min and Max aggregates.
@ 1998-12-10 05:35 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
parent: John Bosch <jbosch@john.cdscc.nasa.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas G. Lockhart @ 1998-12-10 05:35 UTC (permalink / raw)
To: John Bosch <jbosch@john.cdscc.nasa.gov>; +Cc: 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)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-12-10 05:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-12-10 03:55 Min and Max aggregates. John Bosch <jbosch@john.cdscc.nasa.gov>
1998-12-10 05:35 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox