X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id C34559FA5F0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 20 Jun 2006 16:09:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 98610-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 20 Jun 2006 16:09:09 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.198])
	by postgresql.org (Postfix) with ESMTP id 076D39F9998
	for <pgsql-sql@postgresql.org>; Tue, 20 Jun 2006 16:09:08 -0300 (ADT)
Received: by wx-out-0102.google.com with SMTP id h30so1103156wxd
	for <pgsql-sql@postgresql.org>; Tue, 20 Jun 2006 12:09:07 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=jZq7DZuzLCFCoYemEmkiQNfIKqlKrCSjOPZ3EWDJhhpC+go+jBcKzBuR32ab37xcaJwHxGjpcqXrs20si1QC73h9bRN121ZBRbXKIJcUXDoNVZIjvpc7FVoMC8p+ul/yuggEBinyxjg6d5g6k2tgePdMgECjpi25AP33W6EX08I=
Received: by 10.70.103.9 with SMTP id a9mr10900143wxc;
	Tue, 20 Jun 2006 12:09:07 -0700 (PDT)
Received: by 10.70.23.13 with HTTP; Tue, 20 Jun 2006 12:09:07 -0700 (PDT)
Message-ID: <3770ee4b0606201209q75f8f6das1ee3ce246250e5cf@mail.gmail.com>
Date: Tue, 20 Jun 2006 16:09:07 -0300
From: "Eduardo Giovany Schweigert" <sheykina@gmail.com>
To: pgsql-sql@postgresql.org
Subject: =?ISO-8859-1?Q?Problema_com_fun=E7=E3o_UPPER?=
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_104940_4672340.1150830547340"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/231
X-Sequence-Number: 25467

------=_Part_104940_4672340.1150830547340
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Pessoal estou com um problema para usar a fun=E7=E3o Upper, pelo que parece=
 esta
havendo uma incompatibilidade pois qd rodo o sql no linux ((Gentoo) funcion=
a
legal, agora no windows n=E3o ta trazendo os resultados. Em ambos os casos
estou usando o Postgresql 8.1 com PgAdmin 1.4.1, o sql =E9 o seguinte.


select * from pessoa  where UPPER( dsnome ) like'AD=C3O%' limit 10 no linux=
,
retorna as 10 linhas, no windows n=E3o
select * from pessoa  where dsnome like'Ad=E3o%' limit 10 retorna as 10 lin=
has
tanto num qt noutro.


Agrade=E7o qualquer ajuda....


--=20
Eduardo Giovany Schweigert
(51) 9183-7474

------=_Part_104940_4672340.1150830547340
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Pessoal estou com um problema para usar a fun=E7=E3o Upper, pelo que parece=
 esta havendo uma incompatibilidade pois qd rodo o sql no linux ((Gentoo) f=
unciona legal, agora no windows n=E3o ta trazendo os resultados. Em ambos o=
s casos estou usando o Postgresql=20
8.1 com PgAdmin 1.4.1, o sql =E9 o seguinte.<br><br><br><span style=3D"colo=
r: rgb(255, 0, 0);">select * from pessoa&nbsp; where UPPER( dsnome ) like'A=
D=C3O%' limit 10</span> no linux, retorna as 10 linhas, no windows n=E3o<br=
><span style=3D"color: rgb(255, 0, 0);">
select * from pessoa&nbsp; where dsnome like'Ad=E3o%' limit 10</span> retor=
na as 10 linhas tanto num qt noutro.<br><br clear=3D"all"><br>Agrade=E7o qu=
alquer ajuda....<br><br><br>-- <br>Eduardo Giovany Schweigert<br>(51) 9183-=
7474

------=_Part_104940_4672340.1150830547340--