pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedascii-betical sort order?
3+ messages / 2 participants
[nested] [flat]
* ascii-betical sort order?
@ 2009-05-08 17:26 Peter Koczan <pjkoczan@gmail.com>
2009-05-08 17:57 ` Re: ascii-betical sort order? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Koczan @ 2009-05-08 17:26 UTC (permalink / raw)
To: pgsql-sql
Is there some way to do ascii-betical sort ordering in postgres (i.e.
capital letters come before lowercase)? It appears that text ordering
is dictionary-alphabetical. It's useful, but it's different from the
DBMS I'm porting some applications from (SQL Server, in case you were
curious).
It may not be terribly important, but it'd be useful to know in case
it actually is an issue.
I couldn't find any clear answer searching online.
Thanks,
Peter
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ascii-betical sort order?
2009-05-08 17:26 ascii-betical sort order? Peter Koczan <pjkoczan@gmail.com>
@ 2009-05-08 17:57 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-05-08 19:08 ` Re: ascii-betical sort order? Peter Koczan <pjkoczan@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2009-05-08 17:57 UTC (permalink / raw)
To: Peter Koczan <pjkoczan@gmail.com>; +Cc: pgsql-sql
Peter Koczan <pjkoczan@gmail.com> writes:
> Is there some way to do ascii-betical sort ordering in postgres (i.e.
> capital letters come before lowercase)? It appears that text ordering
> is dictionary-alphabetical.
You're apparently using a non-C locale ... you need to re-initdb in
C locale.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ascii-betical sort order?
2009-05-08 17:26 ascii-betical sort order? Peter Koczan <pjkoczan@gmail.com>
2009-05-08 17:57 ` Re: ascii-betical sort order? Tom Lane <tgl@sss.pgh.pa.us>
@ 2009-05-08 19:08 ` Peter Koczan <pjkoczan@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Koczan @ 2009-05-08 19:08 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Kenneth Marshall <ktm@rice.edu>; +Cc: pgsql-sql
On Fri, May 8, 2009 at 12:57 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> You're apparently using a non-C locale ... you need to re-initdb in
> C locale.
On Fri, May 8, 2009 at 12:58 PM, Kenneth Marshall <ktm@rice.edu> wrote:
> Try looking under Localization in the manual (Chapter 22).
Excellent, just what I was looking for. I'll look at this when I have
a bit more time.
Thanks,
Peter
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-05-08 19:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-05-08 17:26 ascii-betical sort order? Peter Koczan <pjkoczan@gmail.com>
2009-05-08 17:57 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-05-08 19:08 ` Peter Koczan <pjkoczan@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox