Many thanks! That clarifies things well.
Jimmy
On Wed, Apr 8, 2020, at 11:49 AM, Adrian Klaver wrote:
> On 4/8/20 7:35 AM, Jimmy Thrasher wrote:
> > Am I missing something about how sorting works?
>
> I believe you are looking for 'C' collation:
>
> test=# sel
I'm seeing some unexpected behavior when sorting some strings, and it indicates
I don't fully understand how postgresql string sorting works.
As I understand it, postgresql sorts strings roughly like strcmp does:
character by character based on encoding value.
In particular, I'm seeing the foll