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

min and max function in time data type columns

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: min and max function in time data type columns
Date: 2000-09-01 15:51:39
Message-ID: 200009011551.e81Fpdm72789@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Peter Boda (plboda(at)yahoo(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
min and max function in time data type columns

Long Description
If  I try to select a min or max value from a column of time data type, I get the message "Unable to select an aggregate function min(time)"
In any other data type columns, min and max works ok.
My database version is 6.5.3
Can somebody give me an idea what is going on?

Sample Code


No file was uploaded with this report


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-09-01 15:54:49
Subject: select on macaddr field type yields incorrect response
Previous:From: RSchieleDate: 2000-09-01 12:01:34
Subject: Handling from UPDATE, SELECT, ... with now rows affected

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