Hello, Cpacejo.
You wrote:
ccc> The following bug has been logged on the website:
ccc> Bug reference: 14064
ccc> Logged by: Chris Pacejo
ccc> Email address: cpacejo@clearskydata.com
ccc> PostgreSQL version: 9.5.2
ccc> Operating system: any
ccc> Description:
ccc> The documentation does not define (nor call out as undefined) the sort order
ccc> of bytea, bit varying, and other sequence types. While the bytea sort order
ccc> is unsurprising (a < b if a is a prefix of b, but b > a if a prefix of b >
ccc> the same length prefix of a), it is not the only such "unsurprising" sort
ccc> order, and it would be helpful to have the guarantee that this sort order
ccc> can be relied upon (especially in concert with range types).
You shouls use explicit type casting for such types.
--
With best wishes,
Pavel mailto:pavel@gf.microolap.com