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:
<snip>
> > Am I missing something about how sorting works?
>
> I believe you are looking for 'C' collation:
>
> test=# select unnest(array[('> N' collate "C") , ('< S' COLLATE "C")])
> as s order by s;
>
> s
> -----
> < S
> > N
> (2 rows)
>
>
> For more information see:
>
> https://www.postgresql.org/docs/12/collation.html