Re: convert result to uppercase

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Victor Spång Arthursson <scooterbabe(at)home(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: convert result to uppercase
Date: 2004-04-20 17:44:37
Message-ID: 20040420174437.GA11203@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 13, 2004 at 14:17:27 +0200,
Victor Spång Arthursson <scooterbabe(at)home(dot)se> wrote:
> Hi!
>
> How do i convert a result to upper/lowercase?
>
> I'ld like to do the following:
>
> SELECT UPPER(lang) from languages;

That's what you do. For example:
bruno=> select upper('test');
upper
-------
TEST
(1 row)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Boes 2004-04-20 17:44:53 Re: plan-reading extensive tutorial?
Previous Message scott.marlowe 2004-04-20 17:41:42 Re: upgrade postgres 7.1 to 7.4.2