Re: [GENERAL] convert result to uppercase

[Andrew Kelly]

On Tue, 2004-04-20 at 23:39, Janning Vygen wrote:
 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

Aren't we now back to the recent thread about UTF-8 and case conversion?
How do you make UPPER and LOWER work on a multi-byte encoded stuff?
How do you get a properly alphabetized return set that, for example, 
contains English, German, French, Spanish, Russian and Turkish records?

Andy


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] convert result to uppercase

[Janning Vygen]

Am Dienstag, 13. April 2004 14:17 schrieb Victor Spng 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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [GENERAL] convert result to uppercase

[Lee Harr]

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?



That looks right to me. Are you getting an error?

lee=# select version();
  version
-
PostgreSQL 7.4.2 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
(1 row)
lee=# select UPPER('MixED CaSes');
   upper
-
MIXED CASES
(1 row)
lee=# select lower('MixED CaSes');
   lower
-
mixed cases
(1 row)
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings