From octaviomaiden@yahoo.com Tue Nov  16 05:34:54 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 566351337990
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <octaviomaiden@yahoo.com>
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

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Hello<br><br>I have migrate a application fro=
m a server with postgres 8.1 to another with 8.3<br>in the new server there=
 are some page that doesn't work because seems to want to compare different=
 data type<br><br>does anyone know if it is a version issue or there is som=
ething Im missing?<br><br>Thanks<br><br>Octavio<br>the error in spanish<br>=
2010-11-15 19:03:21 PET UBICACI=C3N:&nbsp; op_error, parse_oper.c:896<br>20=
10-11-15 19:03:21 PET SENTENCIA:&nbsp; update clamcartga&nbsp; set&nbsp; co=
dusuario=3D$1,fechapro=3D$2,horapro=3D$3,fechaenv=3D$4,flenvmail=3D$5&nbsp;=
 wh<br>ere corrabon=3D$6 and tipoafil=3D$7 and numcaso=3D$8 and corpacien=
=3D$9&nbsp; and tipcarta=3D$10 and corrcart=3D$11<br>2010-11-15 19:06:16 PE=
T ERROR:&nbsp; 42883: el operador no existe: character =3D integer en car=
=C3=A1cter 383<br>2010-11-15 19:06:16 PET HINT:&nbsp; Ning=C3=BAn operador =
coincide con el nombre y el tipo de
 los argumentos. Puede desear agregar convesiones expl=C3=ADcitas de tipos.=
<br><br><br><br></td></tr></table><br>=0A=0A=0A=0A=0A      &nbsp;
--0-1115498898-1289885284=:2140--



From SStearns@internode.com.au Tue Nov  16 05:41:56 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 4E7161335B36
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 16 Nov 2010 01:41:56 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 71707-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 16 Nov 2010 05:41:48 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from imail.internode.com.au (exchht01-ext.internode.com.au
	[203.26.95.185])
	by mail.postgresql.org (Postfix) with ESMTP id 2BEF01337B53
	for <pgsql-admin@postgresql.org>; Tue, 16 Nov 2010 01:41:46 -0400 (AST)
Received: from EXCHMAIL.staff.internode.com.au ([169.254.2.207]) by
	exchht01.staff.internode.com.au ([::1]) with mapi;
	Tue, 16 Nov 2010 16:11:42 +1030
From: Samuel Stearns <SStearns@internode.com.au>
To: Octavio <octaviomaiden@yahoo.com>, "pgsql-admin@postgresql.org"
	<pgsql-admin@postgresql.org>
Date: Tue, 16 Nov 2010 16:11:41 +1030
Subject: Re: ignoring data type
Thread-Topic: [ADMIN] ignoring data type
Thread-Index: AcuFUBhS/bYcB5ugTr+lBfq8qIEeKAAAH7Nw
Message-ID: 
 <68B59BEDCD36854AADBDF17E91B2937A0783A72A35@EXCHMAIL.staff.internode.com.au>
References: <4CE1AAE7.1090406@emolecules.com>
	<924615.2140.qm@web38904.mail.mud.yahoo.com>
In-Reply-To: <924615.2140.qm@web38904.mail.mud.yahoo.com>
Accept-Language: en-US, en-AU
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US, en-AU
Content-Type: multipart/alternative;
	boundary="_000_68B59BEDCD36854AADBDF17E91B2937A0783A72A35EXCHMAILstaff_"
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, LOTS_OF_MONEY=0.001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201011/131
X-Sequence-Number: 36097

--_000_68B59BEDCD36854AADBDF17E91B2937A0783A72A35EXCHMAILstaff_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What does a \d on the table 'clamcartga' in both environments say?  Can you=
 spot any differences between the 8.1 and 8.3 environments?

Sam

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
.org] On Behalf Of Octavio
Sent: Tuesday, 16 November 2010 3:58 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] ignoring data type

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:  op_error, parse_oper.c:896
2010-11-15 19:03:21 PET SENTENCIA:  update clamcartga  set  codusuario=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  an=
d tipcarta=3D$10 and corrcart=3D$11
2010-11-15 19:06:16 PET 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=ADcit=
as de tipos.






--_000_68B59BEDCD36854AADBDF17E91B2937A0783A72A35EXCHMAILstaff_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

<head>

<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-AU link=3Dblue vlink=3Dpurple>

<div class=3DWordSection1>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>What does a \d on the table &#8216;clamcartga&#8217; in both=
 environments
say?=A0 Can you spot any differences between the 8.1 and 8.3 environments?<=
o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>Sam<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm =
0cm 0cm'>

<p class=3DMsoNormal><b><span lang=3DEN-US style=3D'font-size:10.0pt;font-f=
amily:
"Tahoma","sans-serif"'>From:</span></b><span lang=3DEN-US style=3D'font-siz=
e:10.0pt;
font-family:"Tahoma","sans-serif"'> pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] <b>On Behalf Of </b>Octavio<br>
<b>Sent:</b> Tuesday, 16 November 2010 3:58 PM<br>
<b>To:</b> pgsql-admin@postgresql.org<br>
<b>Subject:</b> [ADMIN] ignoring data type<o:p></o:p></span></p>

</div>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<table class=3DMsoNormalTable border=3D0 cellspacing=3D0 cellpadding=3D0>
 <tr>
  <td valign=3Dtop style=3D'padding:0cm 0cm 0cm 0cm'>
  <p class=3DMsoNormal style=3D'margin-bottom:12.0pt'>Hello<br>
  <br>
  I have migrate a application from a server with postgres 8.1 to another w=
ith
  8.3<br>
  in the new server there are some page that doesn't work because seems to =
want
  to compare different data type<br>
  <br>
  does anyone know if it is a version issue or there is something Im missin=
g?<br>
  <br>
  Thanks<br>
  <br>
  Octavio<br>
  the error in spanish<br>
  2010-11-15 19:03:21 PET UBICACI=C3N:&nbsp; op_error, parse_oper.c:896<br>
  2010-11-15 19:03:21 PET SENTENCIA:&nbsp; update clamcartga&nbsp; set&nbsp=
;
  codusuario=3D$1,fechapro=3D$2,horapro=3D$3,fechaenv=3D$4,flenvmail=3D$5&n=
bsp; wh<br>
  ere corrabon=3D$6 and tipoafil=3D$7 and numcaso=3D$8 and corpacien=3D$9&n=
bsp; and
  tipcarta=3D$10 and corrcart=3D$11<br>
  2010-11-15 19:06:16 PET ERROR:&nbsp; 42883: el operador no existe: charac=
ter
  =3D integer en car=C3=A1cter 383<br>
  2010-11-15 19:06:16 PET HINT:&nbsp; Ning=C3=BAn operador coincide con el =
nombre y
  el tipo de los argumentos. Puede desear agregar convesiones expl=C3=ADcit=
as de
  tipos.<br>
  <br>
  <br>
  <o:p></o:p></p>
  </td>
 </tr>
</table>

<p class=3DMsoNormal><span style=3D'font-size:10.0pt;font-family:"Calibri",=
"sans-serif"'><br>
&nbsp;<o:p></o:p></span></p>

</div>

</body>

</html>

--_000_68B59BEDCD36854AADBDF17E91B2937A0783A72A35EXCHMAILstaff_--



From scott.marlowe@gmail.com Tue Nov  16 06:22:51 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 19F6B1337990
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 16 Nov 2010 02:22:51 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 85835-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 16 Nov 2010 06:22:43 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id 4D2E51335B36
	for <pgsql-admin@postgresql.org>; Tue, 16 Nov 2010 02:22:43 -0400 (AST)
Received: by wyb28 with SMTP id 28so339842wyb.19
	for <pgsql-admin@postgresql.org>; Mon, 15 Nov 2010 22:22:42 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=IvVjcDGaUh3p+OWXTqE2YiyM8gJ8G8Ip7OZ72+1+POU=;
	b=UTM74BQFKEhOHKFjl3K/LlQ1RHpxQeMH0sqZG1rUdv9BwykkL2LHadbFYCzw02JcS8
	8FC/ZzjVGfHvriUvQMD2yj8ejNAjjOqSovPxbgAr4xgOCr3ZzUEvnDgKxWp3DRRE2lf7
	tPVtF3ALqcZxty1mvPjLSkRzE81/K1P+OhB3g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=CE1Qx4m4GCWqtcCwPiKs/hF9PE0puUro+nGyRdjkwOfFmvlvoEj/u8TscvfvPDKNpQ
	WqUWQyLnozsMCtB0ndYSFaGh9dxngw5xOk5Wpd8+zAJsHaHiWgsLnUjIvdBd/RWI+m/G
	dcRYtfHdOHoUAqmZPKdMbBgD0y96tlJ2O8Qbc=
MIME-Version: 1.0
Received: by 10.227.72.139 with SMTP id m11mr7116213wbj.104.1289888561699;
	Mon, 15 Nov 2010 22:22:41 -0800 (PST)
Received: by 10.227.134.211 with HTTP; Mon, 15 Nov 2010 22:22:41 -0800 (PST)
In-Reply-To: <924615.2140.qm@web38904.mail.mud.yahoo.com>
References: <4CE1AAE7.1090406@emolecules.com>
	<924615.2140.qm@web38904.mail.mud.yahoo.com>
Date: Mon, 15 Nov 2010 23:22:41 -0700
Message-ID: <AANLkTimt5d9qHct4LDEXb2PJvgS+X=HHjDJA+E9g0anu@mail.gmail.com>
Subject: Re: ignoring data type
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Octavio <octaviomaiden@yahoo.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201011/132
X-Sequence-Number: 36098

On Mon, Nov 15, 2010 at 10:28 PM, Octavio <octaviomaiden@yahoo.com> wrote:
>
> Hello
>
> I have migrate a application from 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 something Im missing?

Starting in 8.3 many automatic conversions from one type to another
were removed because it wasn't always obvious if this was the right
thing to do.  So, you might need to either change some column types,
or cast them explicitly to the type you want to be used for
comparison.



From octaviomaiden@yahoo.com Tue Nov  16 17:15:27 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 043E41337B5B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 16 Nov 2010 13:15:27 -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 11208-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 16 Nov 2010 17:15:19 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from web38908.mail.mud.yahoo.com (web38908.mail.mud.yahoo.com
	[209.191.125.114])
	by mail.postgresql.org (Postfix) with SMTP id A25F31337B4F
	for <pgsql-admin@postgresql.org>; Tue, 16 Nov 2010 13:15:19 -0400 (AST)
Received: (qmail 19077 invoked by uid 60001); 16 Nov 2010 17:15:17 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1289927717; bh=K6ur3dvu4Yact4WbK1ibRfYQQDBaW7A2uTlhDmYENpI=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=yBMNVwsyF1qbbsQOwrcOHseICXUjMK5rB86dblj8dtsGtDjdg3uQrNgg/rIefcJ8y/BgW6hGnjnB1zwDea7C4m+xln/yRGbu3kGhkzVbfgJmUuNo+ml6TY1XHeOFicInRgUbbTe+PEjT3/sjLA3g+C0IAgRKhQlbUSCgXknEr+I=
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:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=oQaC/C542X7NYCkn7RmO4mWsV52K5WAH1Jyz3QZbokxCEGvACmZ3ycW2XIjUIa1/uRiL5rI6yHL6tfOgfX0s07G7o/3CE8t7341qYTFAIJFlCpTTw6eZDB/1z+R8ahvxt18q+4fDl2EvOoU88R80AEshNPMlUReTo9rPVDW2vvY=;
Message-ID: <768188.18183.qm@web38908.mail.mud.yahoo.com>
X-YMail-OSG: 1kYhU4QVM1k0IZC04MEBqOt5vUBSSltWnG5pC0ai4K7v65z
	V7x.lGfDUr9SSx98_YmPWkW4KJWsDH3so7CPP0N7NBrwefc.jfYdqE2lmnX_
	muP0zpEJcpGbHePAKKOQl_nRUOcb.khsF8wbCf4tlSdp.0WHYYDeKSX.2eMa
	AodB42yduSEOz7z4OSKKVp_VCFuO9jzR301OKp6w9TlCqq9sv_IajppgylBJ
	zhUID7w.KcJNxW9llslGasnJr8sZLefyLwDwFeRA6jbKUqot6LsUF_XxC3Vd
	v9O2H72_lKLbNQwKnr_JKdJ84s9NrKkzdx_GTRoTBvOPLr6kFyekXL7p.wdX
	PJgQWRBYeADlurcxWqbhm0rBwy2Azp5CpT2wLQKqze5VcKdZvlKyXumzGHv7
	riF8Pv5I-
Received: from [209.191.68.163] by web38908.mail.mud.yahoo.com via HTTP;
	Tue, 16 Nov 2010 09:15:17 PST
X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.107.285259
Date: Tue, 16 Nov 2010 09:15:17 -0800 (PST)
From: Octavio <octaviomaiden@yahoo.com>
Subject: Re: ignoring data type
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <AANLkTimt5d9qHct4LDEXb2PJvgS+X=HHjDJA+E9g0anu@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1025881682-1289927717=:18183"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.908 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=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/136
X-Sequence-Number: 36102

--0-1025881682-1289927717=:18183
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Thanks Scott

In fact checking the application there are a lots of queries that doesn't m=
ake the conversion, in order to temporally skip this issue,I like to try to=
 import those conversions from the 8.1 version to the actual postgres, how =
can I do that?

Octavio

--- El mar, 11/16/10, Scott Marlowe <scott.marlowe@gmail.com> escribi=F3:

De: Scott Marlowe <scott.marlowe@gmail.com>
Asunto: Re: [ADMIN] ignoring data type
A: "Octavio" <octaviomaiden@yahoo.com>
Cc: pgsql-admin@postgresql.org
Fecha: martes, 16 de noviembre de 2010, 01:22 am

On Mon, Nov 15, 2010 at 10:28 PM, Octavio <octaviomaiden@yahoo.com> wrote:
>
> Hello
>
> I have migrate a application from a server with postgres 8.1 to another w=
ith 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 something Im missin=
g?

Starting in 8.3 many automatic conversions from one type to another
were removed because it wasn't always obvious if this was the right
thing to do.=A0 So, you might need to either change some column types,
or cast them explicitly to the type you want to be used for
comparison.
=0A=0A=0A      
--0-1025881682-1289927717=:18183
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Thanks Scott<br><br>In fact checking the appl=
ication there are a lots of queries that doesn't make the conversion, in or=
der to temporally skip this issue,I like to try to import those conversions=
 from the 8.1 version to the actual postgres, how can I do that?<br><br>Oct=
avio<br><br>--- El <b>mar, 11/16/10, Scott Marlowe <i>&lt;scott.marlowe@gma=
il.com&gt;</i></b> escribi=F3:<br><blockquote style=3D"border-left: 2px sol=
id rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>De: Scott Ma=
rlowe &lt;scott.marlowe@gmail.com&gt;<br>Asunto: Re: [ADMIN] ignoring data =
type<br>A: "Octavio" &lt;octaviomaiden@yahoo.com&gt;<br>Cc: pgsql-admin@pos=
tgresql.org<br>Fecha: martes, 16 de noviembre de 2010, 01:22 am<br><br><div=
 class=3D"plainMail">On Mon, Nov 15, 2010 at 10:28 PM, Octavio &lt;<a ymail=
to=3D"mailto:octaviomaiden@yahoo.com"
 href=3D"/mc/compose?to=3Doctaviomaiden@yahoo.com">octaviomaiden@yahoo.com<=
/a>&gt; wrote:<br>&gt;<br>&gt; Hello<br>&gt;<br>&gt; I have migrate a appli=
cation from a server with postgres 8.1 to another with 8.3<br>&gt; in the n=
ew server there are some page that doesn't work because seems to want to co=
mpare different data type<br>&gt;<br>&gt; does anyone know if it is a versi=
on issue or there is something Im missing?<br><br>Starting in 8.3 many auto=
matic conversions from one type to another<br>were removed because it wasn'=
t always obvious if this was the right<br>thing to do.&nbsp; So, you might =
need to either change some column types,<br>or cast them explicitly to the =
type you want to be used for<br>comparison.<br></div></blockquote></td></tr=
></table><br>=0A=0A=0A=0A=0A      &nbsp;
--0-1025881682-1289927717=:18183--