Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 68E1B65038A
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 Jul 2008 15:28:22 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 99047-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 Jul 2008 15:28:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from is.rice.edu (is.rice.edu [128.42.42.24])
	by postgresql.org (Postfix) with ESMTP id 61F2A65035A
	for <pgsql-admin@postgresql.org>; Mon, 28 Jul 2008 15:28:17 -0300 (ADT)
Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	by is.rice.edu (Postfix) with ESMTP id 99A504182B;
	Mon, 28 Jul 2008 13:28:15 -0500 (CDT)
Received: from is.rice.edu ([128.42.42.24])
	by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	(amavisd-new, port 10024)
	with ESMTP id 07204-03; Mon, 28 Jul 2008 13:28:14 -0500 (CDT)
Received: by is.rice.edu (Postfix, from userid 18612)
	id C18AD41819; Mon, 28 Jul 2008 13:28:14 -0500 (CDT)
Date: Mon, 28 Jul 2008 13:28:13 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Time Type
Message-ID: <20080728182813.GC12016@it.is.rice.edu>
References: <3a0028490807281116g4776d0c0sbaaaf8a372e11997@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3a0028490807281116g4776d0c0sbaaaf8a372e11997@mail.gmail.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200807/220
X-Sequence-Number: 29830

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