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