Steve Crawford <scrawford@pinpointresearch.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