-- Tests for nlssort
\set ECHO none
  name  
--------
 brown
 Purple
 red
 yellow
(4 rows)

  name  
--------
 Purple
 brown
 red
 yellow
(4 rows)

 set_nls_sort 
--------------
 
(1 row)

ERROR:  failed to set the requested LC_COLLATE value [invalid]
CONTEXT:  SQL function "nlssort" statement 1
 set_nls_sort 
--------------
 
(1 row)

  name  
--------
 Purple
 brown
 red
 yellow
(4 rows)

 set_nls_sort 
--------------
 
(1 row)

  name  
--------
 brown
 Purple
 red
 yellow
(4 rows)

  name  
--------
 brown
 Purple
 red
 yellow
 
(5 rows)