Postgres Pro
Downloads
Home   >   mailing lists

Re: Case sensitive order by - Mailing list pgsql-general

From Tom Lane
Subject Re: Case sensitive order by
Date
Msg-id 13754.1050094452@sss.pgh.pa.us
Whole thread Raw
In response to Case sensitive order by  (Deepak Joglekar <deepak.joglekar@nebula-soft.com>)
Responses Re: Case sensitive order by  (Dennis Gearon <gearond@cvc.net>)
Re: Case sensitive order by  (Deepak Joglekar <deepak.joglekar@nebula-soft.com>)
List pgsql-general
Tree view 
Deepak Joglekar <deepak.joglekar@nebula-soft.com> writes:
> I want to do case sensitve sorting on a varchar field.

> That is I will have strings in the varchar field which will have
> character from ascii(32) to ascii(255). I want sort result by ascii
> values.

If you want a straight-ASCII sort without any funny locale sort rules,
you need to be careful to initdb in C locale.

            regards, tom lane

pgsql-general by date:

Previous
From: Kyle
Date:
Subject: Re: How can I get a column INT4 to be UNSIGNED ?
Next
From: "scott.marlowe"
Date:
Subject: Re: How can I get a column INT4 to be UNSIGNED ?