"Josh Berkus" <josh@agliodbs.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