Received: from proxy.bazzanese.com (root@ip161.tol11.interbusiness.it [195.120.106.161]) by hub.org (8.8.8/8.7.5) with ESMTP id HAA15593 for ; Tue, 19 May 1998 07:08:10 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id MAA01110; Tue, 19 May 1998 12:31:42 GMT Date: Tue, 19 May 1998 12:31:42 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: Marin D cc: Jerome Knobl , Mike Lemler , pgsql-sql@postgreSQL.org, sferac@nettuno.it Subject: Re: [SQL] Case in-sensitive searches In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 19 May 1998, Marin D wrote: > > upper()/lower() are defined only for text fields. How to deal with charN ? > version 6.3: prova=> create table a ( var varchar(20), ch char(30)); CREATE prova=> insert into a values ('nome','pippo'); INSERT 76394 1 prova=> select * from a; var |ch ----+------------------------------ nome|pippo (1 row) prova=> select upper(var), upper(ch) from a; upper|upper -----+------------------------------ NOME |PIPPO (1 row) Jose'