"Savita" <savita(dot)halli(at)gmail(dot)com> writes:
> I would like to know if there is anyway we can get the same sorting order
> irreespective of lc_collate value when doing the select query.
You could do "ORDER BY col USING ~<~", but on the whole it's really
better to set LC_COLLATE the way you want.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2009-10-22 15:59:30|
|Subject: Re: BUG #5126: convert_to preventing index scan |
|Previous:||From: Tom Lane||Date: 2009-10-22 15:28:33|
|Subject: Re: BUG #5134: initdb fails with return code 1 |