Skip site navigation (1) Skip section navigation (2)

Re: Time Type

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Time Type
Date: 2008-07-28 18:28:13
Message-ID: 20080728182813.GC12016@it.is.rice.edu (view raw or flat)
Thread:
Lists: 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

In response to

  • Time Type at 2008-07-28 18:16:12 from Rafael Domiciano

Responses

pgsql-admin by date

Next:From: Rafael DomicianoDate: 2008-07-28 18:46:50
Subject: Re: Time Type
Previous:From: Rafael DomicianoDate: 2008-07-28 18:16:12
Subject: Time Type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group