Skip site navigation (1) Skip section navigation (2)

Re: ORDER BY Problem...

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: S(dot)Olloz(at)soid(dot)ch, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ORDER BY Problem...
Date: 2001-06-07 03:09:18
Message-ID: 3B1EF05E.20CE4D2C@tm.ee (view raw or flat)
Thread:
Lists: pgsql-hackers
Christopher Kings-Lynne wrote:
> 
> As far as I know, this is the standard (ASCII-ordered) way of sorting text.
> For example, MySQL does the same thing.
> 

Actually it seems that Severin is using the ASCII locale instead of
en_US or 
some other case-insensitive one.

> >
> > but I want this ouptut:
> >
> > aa
> > ABC
> > ADC
> >
> > What do I wrong?
> >

-----------
Hannu

In response to

pgsql-hackers by date

Next:From: Stephan SzaboDate: 2001-06-07 03:12:46
Subject: Re: behavior of ' = NULL' vs. MySQL vs. Standards
Previous:From: Hannu KrosingDate: 2001-06-07 03:05:44
Subject: Re: Re: Daily Digest V1 #1428

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group