Postgres Pro
Downloads
Home   >   mailing lists

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

From Vyacheslav Kalinin
Subject Re: problem with ORDER BY
Date
Msg-id 9b1af80e0802011635y65476644rf7322e68c56178b9@mail.gmail.com
Whole thread Raw
In response to Re: problem with ORDER BY  (Nicolas KOWALSKI <niko@petole.dyndns.org>)
Responses Re: problem with ORDER BY
List pgsql-general
Tree view
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))

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I can't restart postgres
Next
From: Greg Smith
Date:
Subject: Re: Is PostGreSql's Data storage mechanism "inferior"?