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 <[EMAIL PROTECTED]>
> 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
>
