Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 566351337990 for ; Tue, 16 Nov 2010 01:34:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 98773-07 for ; Tue, 16 Nov 2010 05:34:47 +0000 (UTC) X-Greylist: delayed 00:06:40.369342 by SQLgrey-1.7.6 Received: from web38904.mail.mud.yahoo.com (web38904.mail.mud.yahoo.com [209.191.125.110]) by mail.postgresql.org (Postfix) with SMTP id 08C411335B36 for ; Tue, 16 Nov 2010 01:34:46 -0400 (AST) Received: (qmail 2445 invoked by uid 60001); 16 Nov 2010 05:28:05 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1289885284; bh=h825NAjzp6KlqwhEovgf/xazqzjWcCnr+8oafEJ+cOQ=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=nRer9bhHiXsJ9Kzt+b8y0mc/FFPw8gCbjYYJ7LMXom7hbGzbAcSLTHPRapvduKDe/U9bVHkD+gHESuhTwENFWcbLbBijYsMfd5MKFgH/jvNYc9FndmxH3pXkqIcDfXO4mBBq2fwKykWyr+Be+o45Ku0/56iDYTSNjmQSkgMzsuU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=QMZrdREnn/l4WqM9MdrsnqQyj1sHal4Rk3TZG7dM0ty8OxLzOOWz/eWYY6DQBiWSM7Tx3ui2gmPcRzW9RJge0/6bcASDKqjSLk9drikoX/tCh3e88grXud3Kbdy6BGEFFjYSAKDgREr1rX1D79Y8wbXqilYdA/XSfnC/6Tg3vpc=; Message-ID: <924615.2140.qm@web38904.mail.mud.yahoo.com> X-YMail-OSG: m5C7BkcVM1mHAxrkpa1iZULanShvOLBvOi3wNO5m8i52gja .yVXAepOm0HqZws8hPa.X85BFg8wAHWETWkOa.MDzFC8kAAW9UmZuJelKRge EIpgazEVaE.bUToCQbt_0e3s0IH2z.o6H4Xxmqpe8GR2O.SiIRlmlebCQ0U7 .SMbf6Ls1OyqcNz7SX7GIv80ZJuEgNvlclKQSM7SSF5z1lViSzDAd1fKkBsR 2mAU85QbB0cqx4dtxp.ELFuPlUm_ojDUUuZP6aOk83qLRbRBqC0f2BcpxcZ0 syDVFyZtZ8rqXMKGW90BGTlhrIfLLzO08vLfswSw- Received: from [190.43.144.175] by web38904.mail.mud.yahoo.com via HTTP; Mon, 15 Nov 2010 21:28:04 PST X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259 Date: Mon, 15 Nov 2010 21:28:04 -0800 (PST) From: Octavio Subject: ignoring data type To: pgsql-admin@postgresql.org In-Reply-To: <4CE1AAE7.1090406@emolecules.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1115498898-1289885284=:2140" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.008 tagged_above=-10 required=5 tests=BAYES_20=-0.001, HTML_MESSAGE=0.001, LOTS_OF_MONEY=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/130 X-Sequence-Number: 36096 --0-1115498898-1289885284=:2140 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello I have migrate a application from a server with postgres 8.1 to another wit= h 8.3 in the new server there are some page that doesn't work because seems to wa= nt to compare different data type does anyone know if it is a version issue or there is something Im missing? Thanks Octavio the error in spanish 2010-11-15 19:03:21 PET UBICACI=C3N:=A0 op_error, parse_oper.c:896 2010-11-15 19:03:21 PET SENTENCIA:=A0 update clamcartga=A0 set=A0 codusuari= o=3D$1,fechapro=3D$2,horapro=3D$3,fechaenv=3D$4,flenvmail=3D$5=A0 wh ere corrabon=3D$6 and tipoafil=3D$7 and numcaso=3D$8 and corpacien=3D$9=A0 = and tipcarta=3D$10 and corrcart=3D$11 2010-11-15 19:06:16 PET ERROR:=A0 42883: el operador no existe: character = =3D integer en car=C3=A1cter 383 2010-11-15 19:06:16 PET HINT:=A0 Ning=C3=BAn operador coincide con el nombr= e y el tipo de los argumentos. Puede desear agregar convesiones expl=C3=ADc= itas de tipos. =0A=0A=0A --0-1115498898-1289885284=:2140 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hello

I have migrate a application fro= m a server with postgres 8.1 to another with 8.3
in the new server there= are some page that doesn't work because seems to want to compare different= data type

does anyone know if it is a version issue or there is som= ething Im missing?

Thanks

Octavio
the error in spanish
= 2010-11-15 19:03:21 PET UBICACI=C3N:  op_error, parse_oper.c:896
20= 10-11-15 19:03:21 PET SENTENCIA:  update clamcartga  set  co= dusuario=3D$1,fechapro=3D$2,horapro=3D$3,fechaenv=3D$4,flenvmail=3D$5 = wh
ere corrabon=3D$6 and tipoafil=3D$7 and numcaso=3D$8 and corpacien= =3D$9  and tipcarta=3D$10 and corrcart=3D$11
2010-11-15 19:06:16 PE= T ERROR:  42883: el operador no existe: character =3D integer en car= =C3=A1cter 383
2010-11-15 19:06:16 PET HINT:  Ning=C3=BAn operador = coincide con el nombre y el tipo de los argumentos. Puede desear agregar convesiones expl=C3=ADcitas de tipos.=




=0A=0A=0A=0A=0A   --0-1115498898-1289885284=:2140--