Thread: Bug #818: There are no aggregate functions for type RELTIME

Bug #818: There are no aggregate functions for type RELTIME

From
pgsql-bugs@postgresql.org
Date:
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

Re: Bug #818: There are no aggregate functions for type RELTIME

From
Tom Lane
Date:
pgsql-bugs@postgresql.org writes:
> There are no aggregate functions for type RELTIME

Use type INTERVAL.  Reltime is obsolescent.

            regards, tom lane

答复: [BUGS] Bug #818: There are no aggregate functions for type RELTIME

From
"William"
Date:
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?

http://www.postgresql.org/users-lounge/docs/faq.html