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

Time Type

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Time Type
Date: 2008-07-28 18:16:12
Message-ID: 3a0028490807281116g4776d0c0sbaaaf8a372e11997@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Kenneth MarshallDate: 2008-07-28 18:28:13
Subject: Re: Time Type
Previous:From: Rex MabryDate: 2008-07-28 13:47:18
Subject: FATAL: incorrect checksum in control file

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