averaging interval values

From: "praveen vejandla" <praveen_vejandla(at)rediffmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: averaging interval values
Date: 2002-11-12 15:40:07
Message-ID: 20021112154007.29603.qmail@webmail9.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

I have a table with one varchar field that contains time
intervals.

Is there any way to average or sum those intervals in a table ?

Table name : test

field name : t2 (varchar(40))

it contains all intervals as below

t2

1:01:01
0:25:15
7:09:01
8:09:05

Is there any way to average or sum those above values using a
function?

i could not type cast the varchar(40) to interval type.

How to change the datatype of field from varchar to interval?

Thanks and Regards,
Praveen

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2002-11-12 16:07:41 Re: averaging interval values
Previous Message Christoph Haller 2002-11-12 14:37:52 Re: Output of function into a file