Re: convert result to uppercase

Victor Spång Arthursson wrote:

> 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…


You can do exactly that, upper() and lower() functions exist:
http://www.postgresql.org/docs/7.4/interactive/functions-string.html

--
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.