Re: problem with ORDER BY

"Vyacheslav Kalinin" <vka(at)mgcp(dot)com> writes:

> I am guessing that collation rules are not applied to bytea columns, so one
> can compare text according to C locale anyway if he populates bytea column
> or just does something like
>
> select * from url order by byteain(textout(url))

Thanks for your suggestion; it works well :-)

mon=> select * from url order by byteain(textout(url)) ;
url
-------------------------------
http://imag.fr/
http://www.google.com/
http://www.google.com/reader/
http://www.google.fr/
http://www.postgresql.org/
https://gmail.com/
https://mail.google.com/mail/
https://www.sixxs.net/
(8 rows)

Best regards,
--
Nicolas