consistant output for type interval - Mailing list pgsql-novice

From Dorin Grunberg
Subject consistant output for type interval
Date
Msg-id 4.3.2.7.2.20010716110416.00b56240@pophost
Whole thread Raw
Responses Re: consistant output for type interval
List pgsql-novice
Hi,

I have a table where one of the columns is of type interval.

When I calculate the sum of that column the results are looking like this:

1 day 5:30
1 day
05:45

I would like to have it consistent in the HH:MM format and, if it is not
possible this way, perhaps something like:

1 day 05:30
1 day 00:00
0 day 05:45

I know I can manipulate the results on the Perl or PHP side but I thought
that there might be another way.

Thanks,

Dorin


pgsql-novice by date:

Previous
From: Stoffel van Aswegen
Date:
Subject: FW: GROUP BY and aggregate functions
Next
From: Henry House
Date:
Subject: Re: GROUP BY and aggregate functions