convert result to uppercase - Mailing list pgsql-general

From Victor Spång Arthursson
Subject convert result to uppercase
Date
Msg-id 8782C340-8D44-11D8-80DF-00039344A3C4@home.se
Whole thread Raw
Responses Re: convert result to uppercase
Re: convert result to uppercase
Re: convert result to uppercase
List pgsql-general
Hi!

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…

Sincerely

Victor

pgsql-general by date:

Previous
From: Alexander Cohen
Date:
Subject: cursor questions
Next
From: "Alan Treece"
Date:
Subject: plpgsql: cannot connect to SPI manager