How do i convert a result to upper/lowercase?
I'ld like to do the following:
SELECT UPPER(lang) from languages;
and get for example "uk" as "UK", "dk" AS "DK" and so on?
That looks right to me. Are you getting an error?
lee=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.4.2 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
(1 row)lee=# select UPPER('MixED CaSes');
upper
-------------
MIXED CASES
(1 row)lee=# select lower('MixED CaSes');
lower
-------------
mixed cases
(1 row)_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
