On Wed, 2005-01-19 at 11:24 -0800, SCassidy(at)overlandstorage(dot)com wrote:
> [non-word character being ignored by ORDER BY]
...
> testdb1=> show LC_COLLATE;
> lc_collate
> -------------
> en_US.UTF-8
> (1 row)
this is a 'feature' of your en_US locale:
bash$ export LC_COLLATE=en_US
bash$ (echo "usra";echo "usrq";echo "/usr/lib")| sort
usra
/usr/lib
usrq
bash$ export LC_COLLATE=C
bash$ (echo "usra";echo "usrq";echo "/usr/lib")| sort
/usr/lib
usra
usrq
maybe you should have run initdb with LC_COLLATE=C
gnari