Re: Sort order confusion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sort order confusion
Date: 2004-02-06 02:08:14
Message-ID: 20452.1076033294@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> Not exactly. I _DO_ want it in ASCII character set order which
> includes spaces (0x20) sorting ahead of digits (0x30 - 0x39). This is
> not what is happening. The first sort is some SQL sort order that
> seems to ignore certain characters.

Sounds to me like you've got the database in a non-C locale. See past
discussions ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-02-06 02:27:12 Re: newbie question... how do I get table structure?
Previous Message Jenny Zhang 2004-02-06 01:49:34 pgsql 7.4.1 copy - end-of-copy marker corrupt