BUG #14064: Sort order of bytea, etc. not defined - Mailing list pgsql-bugs

From cpacejo@clearskydata.com
Subject BUG #14064: Sort order of bytea, etc. not defined
Date
Msg-id 20160404203304.15198.54263@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14064: Sort order of bytea, etc. not defined  (Pavel Golub <pavel@microolap.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14064
Logged by:          Chris Pacejo
Email address:      cpacejo@clearskydata.com
PostgreSQL version: 9.5.2
Operating system:   any
Description:

The documentation does not define (nor call out as undefined) the sort order
of bytea, bit varying, and other sequence types.  While the bytea sort order
is unsurprising (a < b if a is a prefix of b, but b > a if a prefix of b >
the same length prefix of a), it is not the only such "unsurprising" sort
order, and it would be helpful to have the guarantee that this sort order
can be relied upon (especially in concert with range types).

pgsql-bugs by date:

Previous
From: Emre Hasegeli
Date:
Subject: Re: BUG #14054: "create index using gist ..." on large table never completes.
Next
From: bert.vanhertum.ext@klav.be
Date:
Subject: BUG #14065: Dutch_Belgium locale not working correctly