From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
Cc: | Postgres SQL List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: order by |
Date: | 2003-03-26 18:44:33 |
Message-ID: | 20030326104353.P63544-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wed, 26 Mar 2003, Jodi Kanter wrote:
> Is there a known problem with the SQL order by clause within postgres
> version 7.2.3? I am trying to sort a field which holds file names that
> have some spaces as well non-alphanumeric characters, including
> underscores (see below).
>
> The results of:
> select study_name from study order by study_name;
>
>
> Study1a
> Study 1b
> Study 1c
> Study1d
>
>
> The results of sorting in Perl (which uses Linux's underlying sort function)
>
> Study 1c
> Study 1b
> Study1a
> Study1d
>
> Is there any way around this difference? Blank spaces should show up
> first in the sort.
Are you in "C" locale or something like "en_US"? In the latter, the first
is the "correct" ordering.
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-03-26 19:07:22 | Re: How can I pass an array from PostgreSQL to C (libpq)? |
Previous Message | Tony Reina | 2003-03-26 18:24:46 | How can I pass an array from PostgreSQL to C (libpq)? |