Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 145106500D5
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 Jul 2008 15:46:58 -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 14434-10 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 Jul 2008 15:46:50 -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.154])
	by postgresql.org (Postfix) with ESMTP id 1A1B264FF2F
	for <pgsql-admin@postgresql.org>; Mon, 28 Jul 2008 15:46:51 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so2847683fgg.23
	for <pgsql-admin@postgresql.org>; Mon, 28 Jul 2008 11:46:50 -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:cc:in-reply-to:mime-version:content-type:references;
	bh=LC1E0TmZm8uL4fmHogfggSkZ6Cl6zHZK9zjKDUoCTCk=;
	b=xTWI1u2GwpqzLK+x1CCIAylAThO9l/fLUleQpBQZyQRLHU3pNmdJ4UJr5xKfdV4Ch6
	CSk4wKfTagKJqSnqgHCMIrIyDrg9Sk3oxwAmzDlyqABzt1yXPoBWIJO/Y1M9Wfu8g3hF
	0y/GVvZmXJ9USZCIDCF7N6Y5ohhlyCwsJvvAw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=TRodhjgf2d9L4+h4m5VQBTai0LtyXPBqMDps7mYpomymUWwPRxwvclA8/KwCQN7It+
	RpXBRlTK2IAiBsVzPTmUIkmSRGxBltvAmpm9GQCJJmMSSeczN6Nc7M+mDqi1NC9jyKj7
	I39EInUODuyHmfQ7nwjOM/2u7ydKMy4YJsNq0=
Received: by 10.86.84.5 with SMTP id h5mr2850501fgb.58.1217270810624;
	Mon, 28 Jul 2008 11:46:50 -0700 (PDT)
Received: by 10.86.36.13 with HTTP; Mon, 28 Jul 2008 11:46:50 -0700 (PDT)
Message-ID: <3a0028490807281146x3f62b7f4hb140512e9cad65e2@mail.gmail.com>
Date: Mon, 28 Jul 2008 15:46:50 -0300
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: "Kenneth Marshall" <ktm@rice.edu>
Subject: Re: Time Type
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <20080728182813.GC12016@it.is.rice.edu>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_37369_4750747.1217270810625"
References: <3a0028490807281116g4776d0c0sbaaaf8a372e11997@mail.gmail.com>
	<20080728182813.GC12016@it.is.rice.edu>
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/221
X-Sequence-Number: 29831

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

I'm doing the following SQL and i getting error:

SELECT
  flc.cod_fila_negociacao,
  1 AS ordem
FROM cbrflcfila_cobranca flc
WHERE
  flc.num_prioridade = 0 AND
  flc.hor_distribuicao +
    ( SELECT pac.num_tempo_espera_urgente
      FROM cbrpacparametro_cobranca pac
    )
  <= CURRENT_TIME

I need to get a time to do a condition.
I couldn't do the SQL

2008/7/28 Kenneth Marshall <ktm@rice.edu>

> 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
>

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

<div dir="ltr">I&#39;m doing the following SQL and i getting error:<br><br>SELECT<br>&nbsp; flc.cod_fila_negociacao,<br>&nbsp; 1 AS ordem<br>FROM cbrflcfila_cobranca flc<br>WHERE<br>&nbsp; flc.num_prioridade = 0 AND<br>&nbsp; flc.hor_distribuicao + <br>
&nbsp;&nbsp;&nbsp; ( SELECT pac.num_tempo_espera_urgente<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM cbrpacparametro_cobranca pac<br>&nbsp;&nbsp;&nbsp; )<br>&nbsp; &lt;= CURRENT_TIME<br><br>I need to get a time to do a condition.<br>I couldn&#39;t do the SQL<br><br><div class="gmail_quote">
2008/7/28 Kenneth Marshall <span dir="ltr">&lt;<a href="mailto:ktm@rice.edu">ktm@rice.edu</a>&gt;</span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
What exactly are you hoping for? I do not think that adding two<br>
times makes sense. Maybe you want one to be an interval?<br>
<br>
Ken<br>
<div><div></div><div class="Wj3C7c"><br>
On Mon, Jul 28, 2008 at 03:16:12PM -0300, Rafael Domiciano wrote:<br>
&gt; Hi there,<br>
&gt;<br>
&gt; I&#39;m trying to do some as following and I couldn&#39;t:<br>
&gt; select &#39;00:01:00&#39;::time + &#39;00:10:00&#39;::time<br>
&gt; ERROR: &nbsp;operator is not unique: time without time zone + time without time<br>
&gt; zone at character 127<br>
&gt; HINT: &nbsp;Could not choose a best candidate operator. You might need to add<br>
&gt; explicit type casts.<br>
&gt;<br>
&gt; Postgres version: 8.3.3<br>
&gt;<br>
&gt; Anyone knows anything?<br>
&gt;<br>
&gt; Regards,<br>
&gt;<br>
&gt; Rafael Domiciano<br>
</div></div></blockquote></div><br></div>

------=_Part_37369_4750747.1217270810625--