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'