From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: John Bosch <jbosch@john.cdscc.nasa.gov>
Cc: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Min and Max aggregates.
Date: Thu, 10 Dec 1998 05:35:31 +0000
Message-ID: <366F5DA3.471929A6@alumni.caltech.edu> (raw)
References: <366F4639.AA900B60@john.cdscc.nasa.gov>
> ... 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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, jbosch@john.cdscc.nasa.gov
Subject: Re: [INTERFACES] Min and Max aggregates.
In-Reply-To: <366F5DA3.471929A6@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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