Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Min and Max aggregates.

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: John Bosch <jbosch(at)john(dot)cdscc(dot)nasa(dot)gov>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Min and Max aggregates.
Date: 1998-12-10 05:35:31
Message-ID: 366F5DA3.471929A6@alumni.caltech.edu (view raw or flat)
Thread:
Lists: 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)

In response to

pgsql-interfaces by date

Next:From: Venkatesh RaghavanDate: 1998-12-10 08:09:27
Subject: Pgaccess database connection fails
Previous:From: John BoschDate: 1998-12-10 03:55:37
Subject: Min and Max aggregates.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group