Re: Time Type - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: Time Type
Date
Msg-id 20080728182813.GC12016@it.is.rice.edu
Whole thread Raw
In response to Time Type  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
Responses Re: Time Type  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
List pgsql-admin
What exactly are you hoping for? I do not think that adding two
times makes sense. Maybe you want one to be an interval?

Ken

On Mon, Jul 28, 2008 at 03:16:12PM -0300, Rafael Domiciano wrote:
> Hi there,
>
> I'm trying to do some as following and I couldn't:
> select '00:01:00'::time + '00:10:00'::time
> ERROR:  operator is not unique: time without time zone + time without time
> zone at character 127
> HINT:  Could not choose a best candidate operator. You might need to add
> explicit type casts.
>
> Postgres version: 8.3.3
>
> Anyone knows anything?
>
> Regards,
>
> Rafael Domiciano

pgsql-admin by date:

Previous
From: "Rafael Domiciano"
Date:
Subject: Time Type
Next
From: "Rafael Domiciano"
Date:
Subject: Re: Time Type