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

From Janning Vygen
Subject Re: convert result to uppercase
Date
Msg-id 200404202339.25145.vygen@gmx.de
Whole thread Raw
In response to convert result to uppercase  (Victor Spång Arthursson <scooterbabe@home.se>)
Responses Re: convert result to uppercase
List pgsql-general
Am Dienstag, 13. April 2004 14:17 schrieb Victor Spång Arthursson:
> Hi!
>
> How do i convert a result to upper/lowercase?

This is a question

> SELECT UPPER(lang) from languages;

and this is the answer. It works exactly like this:

SELECT UPPER('dk');

results in 'DK'

kind regards,
Janning


pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Downgrading from Postgresql 7.4 to 7.1
Next
From: jurgen.defurne@pandora.be (Jurgen Defurne)
Date:
Subject: Re: Python to postgresql interface