Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0194B2E327E for ; Tue, 5 Feb 2008 15:20:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89642-01-4 for ; Tue, 5 Feb 2008 15:20:32 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id 22BA82E32D2 for ; Tue, 5 Feb 2008 15:18:56 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so3534433waf.5 for ; Tue, 05 Feb 2008 11:18:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=6mylG1ebB3V4X0LzDZ8IkcTTC+habEv2ql1grZVozwE=; b=ZakmxsQKc1Hs14EwYjjGiPyLnSw5jHXN8sdYryO3+QJcWC3ya0VyNOtikKjJRiZpOgjdGjw15Zw39SB7WG5/ounT/o47euiJWOJi5VEaDkRiDSNAEAkznf1dgWT1oxxTwH6LMg/Y2AGhuDW588KV7zD7WVyYuEU99kksfqTca28= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PcsZM5F4H+OvL8JL/bW4LqRtunYM4SoOSjUnYjFd85gpJdsStIjkRqRa9UYtdFTige4voih6Z0bje+99EHJAtxPSOq5KbqLcbswmhX6opQvkEytruaeyMw/+ngIXxEqYdcG1o/DvqJqlCcdDd2RznSiBjsrTCWbuTUxo52JdYro= Received: by 10.114.191.1 with SMTP id o1mr344551waf.66.1202239134821; Tue, 05 Feb 2008 11:18:54 -0800 (PST) Received: by 10.114.74.9 with HTTP; Tue, 5 Feb 2008 11:18:54 -0800 (PST) Message-ID: Date: Tue, 5 Feb 2008 14:18:54 -0500 From: "Jaime Casanova" To: "Franklin Haut" Subject: Re: Cast in PG 8.3 Cc: pgsql-sql@postgresql.org In-Reply-To: <47A8B788.6010304@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <47A8B788.6010304@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/18 X-Sequence-Number: 30109 On Feb 5, 2008 2:22 PM, Franklin Haut wrote: > > > Hi all, > > I=B4m testing the new version of PostgreSQL in windows plataform but i ha= ve a > problem. > > > In PG 8.2 > > Create Table temp (id int4); > insert into temp values (1215); > insert into temp values (1216); > insert into temp values (1217); > insert into temp values (1218); > insert into temp values (1219); > insert into temp values (1220); > insert into temp values (1221); > insert into temp values (1222); > SELECT * FROM TEMP WHERE id ilike ('%122%'); > > return ok, 3 rows (1220, 1221 and 1222) > > > > In PG 8.3 > > Create Table temp (id integer); > insert into temp values (1215); > insert into temp values (1216); > insert into temp values (1217); > insert into temp values (1218); > insert into temp values (1219); > insert into temp values (1220); > insert into temp values (1221); > insert into temp values (1222); > SELECT * FROM TEMP WHERE id ilike ('%122%'); > > Error: > operator does not exist: integer ~~* unknown at character 31 > HINT: No operator matches the given name and argument type(s). > You might need to add explicit type casts. > did you read the release notes? http://www.postgresql.org/docs/current/static/release-8-3.html """ Non-character data types are no longer automatically cast to TEXT (Peter, T= om) """ --=20 regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook