convert result to uppercase

From: Victor Spång Arthursson <scooterbabe(at)home(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: convert result to uppercase
Date: 2004-04-13 12:17:27
Message-ID: 8782C340-8D44-11D8-80DF-00039344A3C4@home.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cott Lang 2004-04-13 12:40:34 Re: Filesystem vs. Postgres for images
Previous Message Holger Klawitter 2004-04-13 10:56:09 Re: Filesystem vs. Postgres for images