"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