Re: BUG #14064: Sort order of bytea, etc. not defined

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