order by x using varchar_pattern_ops
Started by Scott Marloweover 17 years ago2 messagesgeneral
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?
Re: order by x using varchar_pattern_ops
"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