Thread: order by x using varchar_pattern_ops

OK, so I know about varchar_pattern_ops for things like matching with
like in a non C locale.

But is there a way to force a use of varchar_pattern_ops on a column
used in an order by?

"Scott Marlowe" <scott.marlowe@gmail.com> 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