[HACKERS] ORDER BY Problem...
Hello... Why does Postgresql order the uppercase letters first? I have e.g. a table with one row an in this row there are follow values: row1 ADC aa ABC With this select-syntax select * from table order by row1 I become this output ABC ADC aa but I want this ouptut: aa ABC ADC What do I wrong? -- Gruss: Severin Olloz ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] ORDER BY Problem...
Hello... Why does Postgresql order the uppercase letters first? I have e.g. a table with one row an in this row there are follow values: row1 ADC aa ABC With this select-syntax select * from table order by row1 I become this output ABC ADC aa but I want this ouptut: aa ABC ADC What do I wrong? This will not solve your problem, but a way around this is to sort on upper (row1): # select * from test order by col1; col1 -- ABCD AD Abc (3 rows) # select * from test order by upper(col1); col1 -- Abc ABCD AD (3 rows) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] ORDER BY Problem...
Christopher Kings-Lynne [EMAIL PROTECTED] writes: As far as I know, this is the standard (ASCII-ordered) way of sorting text. No, it's the we don't know anything about text, but we can compare their numeric values approach. -- Trond Eivind Glomsrød Red Hat, Inc. ---(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