| From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Very puzzling sort behavior |
| Date: | 2015-09-11 00:11:21 |
| Message-ID: | CAD3a31UYYZCR4M2s5oUQAOCiQ=ABW=OK=6RFfNxobY23s+4tMQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 10, 2015 at 3:03 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
wrote:
> On Thu, Sep 10, 2015 at 02:54:31PM -0700, Ken Tanzer wrote:
> > Thanks, but I guess I should have been clearer. Thanks to y'all
> wonderful
> > mailing list folks, I get it now as to why the two sorts are not the
> same.
> > I'm hoping for practical suggestions or advice about how to get C locale
> > sorting without having to rewrite all my existing queries.
>
> Why not change the collation for the column?
> http://www.postgresql.org/docs/9.4/interactive/sql-altertable.html
>
>
Hmm... that sounds promising. And less drastic than rewriting the whole
database. I'll have to ponder that one, and thanks for the suggestion!
Cheers,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venkata Balaji N | 2015-09-11 05:22:52 | Re: avoid lock conflict between SELECT and TRUNCATE |
| Previous Message | Joe Conway | 2015-09-10 22:49:43 | Re: Very puzzling sort behavior |