cast

From: Judith Altamirano Figueroa <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: cast
Date: 2005-10-14 18:08:43
Message-ID: 1129313323.4577.55.camel@Desarrollo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query
is the next:

select n.factura,
n.venta_neta,
c.nombre_cli || ' ' || c.apellido_pat_cli || ' ' || coalesce
(c.apellido_mat_cli,''),
date(n.fecha_hora_factura),
o.nombre_oft
from nota_venta n,
clientes c,
oft_central o
where date(n.fecha_hora_factura) >= '2005-10-01' and
date(n.fecha_hora_factura) <= '2005-10-14' and
n.id_cliente = c.id_cliente and
cast(n.udf4 as integer) = o.id_oft_central and
n.factura is not null and
n.s_factura != 'T'
order by o.nombre_oft";

it aparently returns an error because the cast, but I need to do the
cast, does somebody knows how can I change the cast but with the same
result, thnks!!!!

Responses

  • Re: cast at 2005-10-14 18:19:03 from Andrew Sullivan
  • Re: cast at 2005-10-14 18:20:07 from Dan Feiveson

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2005-10-14 18:19:03 Re: cast
Previous Message Tyler Kellen 2005-10-14 18:06:36 FULL OUTER JOIN Question (mistake)