Horton

Re: [SQL] Case in-sensitive searches

jose' soares <sferac@bo.nettuno.it>

View thread View on postgr.es
From: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
To: Marin D <marin@iclub.techno-link.com>
Cc: Jerome Knobl <jknobl@mandanet.ch>, Mike Lemler <coronach@datacruz.com>, pgsql-sql@postgreSQL.org, sferac@nettuno.it
Date: 1998-05-19T12:31:42Z
Lists: pgsql-sql 
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'