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