Re: data order problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: "jack" <datactrl(at)tpg(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org
Subject: Re: data order problem
Date: 2002-04-15 04:55:56
Message-ID: 7190.1018846556@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

"Josh Berkus" <josh(at)agliodbs(dot)com> writes:
>> why is it not ordered by ASCII sequence. And I found if I put in a
>> data such
>> as '<ABC>', it goes to last one when you do the same query.

> I'm sorry, you're going to have to be more explicit. I don't
> understand what problem you are having with the order given.

I think he's using a non-C locale and expecting C-locale sort order.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message jack 2002-04-15 06:40:03 Re: data order problem
Previous Message Josh Berkus 2002-04-15 04:53:02 Re: data order problem

Browse pgsql-sql by date

  From Date Subject
Next Message jack 2002-04-15 06:40:03 Re: data order problem
Previous Message Josh Berkus 2002-04-15 04:53:02 Re: data order problem