"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> But is there a way to force a use of varchar_pattern_ops on a column
> used in an order by?

ORDER BY x USING ~<~    ("asc" direction)
ORDER BY x USING ~>~    ("desc" direction)

(assuming those are the right names of the operators, I'm too lazy
to check)

                        regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to