Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 99C9264FCEF for ; Tue, 29 Jul 2008 00:50:23 -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 38100-05-6 for ; Tue, 29 Jul 2008 00:49:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n3b.bullet.mail.ac4.yahoo.com (n3b.bullet.mail.ac4.yahoo.com [76.13.13.73]) by postgresql.org (Postfix) with SMTP id C4B28650142 for ; Tue, 29 Jul 2008 00:45:55 -0300 (ADT) Received: from [76.13.13.26] by n3.bullet.mail.ac4.yahoo.com with NNFMP; 29 Jul 2008 03:42:00 -0000 Received: from [76.13.10.169] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 29 Jul 2008 03:42:00 -0000 Received: from [127.0.0.1] by omp110.mail.ac4.yahoo.com with NNFMP; 29 Jul 2008 03:42:00 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 507672.88109.bm@omp110.mail.ac4.yahoo.com Received: (qmail 57210 invoked by uid 60001); 29 Jul 2008 03:42:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=q+5UA3NwsR50PZBp+HpTWHQS4gFAVTPmlnUDZoKsUtuNrsGfaQRTuSHQboaLPGSC+HYghRmliciK7Z/X3UDvkhF4lqIXW9u3BjbozGWilzW95F4IgDo3KsE3poNL4/XJ/uFEm6jQnJ6M+s+vFJ+DVxIf58oRATOSMaV9TEZ1A88=; Received: from [201.242.104.82] by web59507.mail.ac4.yahoo.com via HTTP; Mon, 28 Jul 2008 20:42:00 PDT X-Mailer: YahooMailWebService/0.7.218 Date: Mon, 28 Jul 2008 20:42:00 -0700 (PDT) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: Time Type To: "pgsql-admin@postgresql.org" , Rafael Domiciano In-Reply-To: <3a0028490807281116g4776d0c0sbaaaf8a372e11997@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <322763.57072.qm@web59507.mail.ac4.yahoo.com> 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/222 X-Sequence-Number: 29832 you try to do something like this select '00:01'::time + interval '10 minutes' --- On Mon, 7/28/08, Rafael Domiciano wrote: > From: Rafael Domiciano > Subject: [ADMIN] Time Type > To: "pgsql-admin@postgresql.org" > Date: Monday, July 28, 2008, 6:16 PM > 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