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 (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql