Hi Scott, Scott Marlowe wrote:
Sorry, I mentioned the wrong operator before, it's ~>~ and ~<~ (asc versus desc):smarlowe=# create table col_test (a text); CREATE TABLE smarlowe=# insert into col_test (a) values ('"quoted"'),('Abc'),('123'); INSERT 0 3 smarlowe=# select * from col_test order by a; a ---------- 123 Abc "quoted" (3 rows) smarlowe=# select * from col_test order by a using ~<~; a ---------- "quoted" 123 Abc (3 rows) smarlowe=# select * from col_test order by a using ~>~; a ---------- Abc 123 "quoted" (3 rows)
Those operators give me "C"-style collation in the database that is using "en_US" collation, but what I would really prefer is the reverse. BTW, where are those operators documented? Neither Google nor Yahoo nor postgresql.org search return anything.
Joe -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
