Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 11B1C650496
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 Jul 2008 15:19:49 -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 90688-01-3 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 Jul 2008 15:19:41 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.157])
	by postgresql.org (Postfix) with ESMTP id E85776504EF
	for <pgsql-admin@postgresql.org>; Mon, 28 Jul 2008 15:16:13 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so2836696fgg.23
	for <pgsql-admin@postgresql.org>; Mon, 28 Jul 2008 11:16:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=3SRARNac5HBtC6xvfv7eEaJCtj1WIPMruGLjRmCI3w8=;
	b=FwaGJLhKVy6G4+H4UKgGOxyqc6MErXllibjnfHVjrSNP+hTKreQT8YenUn3iVgZ1lx
	4v+UfoB0f8EEX+Lh4HvOvxaJVMHFg0TESbZII1yAFEQ0JMbfd5Ty4We2HV8l9Jc2TdoW
	/75xhpq+psF2eOrnNHXLbQyJ0b1KOSKtb066U=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=ChKBUnMI5kPRHVSar7gYx0HeWNdeuthjA4Tt3FFNjL2Q2dzj4uQHZP3hXv30UjKPgi
	kGz16OJ4UGb78+6IHeSencg3cf0tL+9vMW1A8PSud2Fww6czD+L2ijVouXmEUbEfkxGl
	vfdkyu4sP3sQjB2i6ai0lpTFTb1alba5YWpNs=
Received: by 10.86.90.13 with SMTP id n13mr2856814fgb.3.1217268972242;
	Mon, 28 Jul 2008 11:16:12 -0700 (PDT)
Received: by 10.86.36.13 with HTTP; Mon, 28 Jul 2008 11:16:12 -0700 (PDT)
Message-ID: <3a0028490807281116g4776d0c0sbaaaf8a372e11997@mail.gmail.com>
Date: Mon, 28 Jul 2008 15:16:12 -0300
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Time Type
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_36922_8790975.1217268972250"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/219
X-Sequence-Number: 29829

------=_Part_36922_8790975.1217268972250
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_36922_8790975.1217268972250
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Hi there,<br><br>I&#39;m trying to do some as following and I couldn&#39;t:<br>select &#39;00:01:00&#39;::time + &#39;00:10:00&#39;::time<br>ERROR:&nbsp; operator is not unique: time without time zone + time without time zone at character 127<br>
HINT:&nbsp; Could not choose a best candidate operator. You might need to add explicit type casts.<br><br>Postgres version: 8.3.3<br><br>Anyone knows anything?<br><br>Regards,<br><br>Rafael Domiciano<br></div>

------=_Part_36922_8790975.1217268972250--