Postgres Pro
Downloads
Home   >   mailing lists

Re: order by x using varchar_pattern_ops - Mailing list pgsql-general

From Tom Lane
Subject Re: order by x using varchar_pattern_ops
Date
Msg-id 10738.1219282188@sss.pgh.pa.us
Whole thread Raw
In response to order by x using varchar_pattern_ops  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: WAL archiving to network drive
Next
From: "Merlin Moncure"
Date:
Subject: Re: plpgsql - sorting result set