Bug #818: There are no aggregate functions for type RELTIME
Paul Mamin (magamos@mail.ru) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
There are no aggregate functions for type RELTIME
Long Description
create table a (b reltime);
insert into a values ('00:02:00');
select sum(b) from a;
sum
-----
120
select min(b) from a;
min
-----
120
Linux, PostgreSQL 7.2.3
Sample Code
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
There are no aggregate functions for type RELTIME
Use type INTERVAL. Reltime is obsolescent.
regards, tom lane
it has already been fixed in 7.3b2
-----邮件原件-----
发件人: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] 代表 pgsql-bugs@postgresql.org
发送时间: 2002年11月14日 21:50
收件人: pgsql-bugs@postgresql.org
主题: [BUGS] Bug #818: There are no aggregate functions for type RELTIME
Paul Mamin (magamos@mail.ru) reports a bug with a severity of 4 The
lower the number the more severe it is.
Short Description
There are no aggregate functions for type RELTIME
Long Description
create table a (b reltime);
insert into a values ('00:02:00');
select sum(b) from a;
sum
-----
120
select min(b) from a;
min
-----
120
Linux, PostgreSQL 7.2.3
Sample Code
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?