Re: convert result to uppercase - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: convert result to uppercase
Date
Msg-id 20040420174437.GA11203@wolff.to
Whole thread Raw
In response to convert result to uppercase  (Victor Spång Arthursson <scooterbabe@home.se>)
List pgsql-general
On Tue, Apr 13, 2004 at 14:17:27 +0200,
  Victor Spång Arthursson <scooterbabe@home.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)

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Downgrading from Postgresql 7.4 to 7.1
Next
From: Peter Lindquist
Date:
Subject: index elements of a composite?