Re: How to order varchar data by word

Hello, Adrian.

Thank you for your email.

I am not using any SQL at this time, but I 'd like to understand
what is exactly the criterion that the ORDER BY uses to order text.

Giving you some background :

I need to make an efficient join between data generated by my program
and data output by postgres and of course, it is mandatory that both lists
of records
be ordered using the same criterion.
I need to figure out what is exactly the criterion used by postgres so I can
mimic it on my
program. I thought it was ordinal, but it seems it isnt, as the @ symbol
comes before the 0 (zero).
According to ASCII numeric codes, it shouldn't

If any one can explain me exactly how the order by clause works on varchars,
I 'd really appreciate it.

I've already examined documentation carefully, but couldn't find it. Maybe I
looked on the wrong place...

Best,
Oliveiros

----- Original Message -----
From: "Adrian Klaver" <aklaver(at)comcast(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "Oliveiros C," <oliveiros(dot)cristina(at)marktest(dot)pt>
Sent: Wednesday, October 14, 2009 9:54 PM
Subject: Re: [SQL] How to order varchar data by word

> On Wednesday 14 October 2009 7:13:22 am Oliveiros C, wrote:
>> Hello, list.
>>
>> I have a table with a varchar field that I would like to order by word,
>> not
>> by ordinal, which seems to be the default on postgres.
>>
>> Does anyone have a clue on how this can be done?
>>
>> Many thanx in advance,
>>
>> Best,
>> Oliveiros
>
> Can you show the SQL you are using?
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql