Re: problem with ORDER BY - Mailing list pgsql-general

"Vyacheslav Kalinin" <vka@mgcp.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