Re: [SQL] Case in-sensitive searches - Mailing list 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'