From: Richard Huxton <dev@archonet.com>
To: Kristian Jörg <krjg@devo.se>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sort order with spaces?
Date: Wed, 17 Sep 2003 14:50:30 +0100
Message-ID: <200309171450.30382.dev@archonet.com> (raw)
In-Reply-To: <3F685600.3010606@devo.se>
References: <3F682DB3.6080905@devo.se>
<3F6853E4.3000604@devo.se>
<3F685600.3010606@devo.se>
On Wednesday 17 September 2003 13:39, Kristian Jörg wrote:
> Kristian Jörg wrote:
> > Richard Huxton wrote:
> >>>
> >>>LUNDGREN
> >>>M L R
> >>>MACDOWELL
> >>>MUSCLE
> >>>
> >>>But in Postgres I get this order:
> >>>
> >>>LUNDGREN
> >>>MACDOWELL
> >>>M L R
> >>>MUSCLE
> >>
> Woops, a type above. My sql is of course:
> select * from mytable where normtext>= 'LU' order by normtext;
richtest=# select * from foo order by b;
a | b
---+-----------
1 | LUNDGREN
2 | M L R
3 | MACDOWELL
4 | MUSCLE
(4 rows)
LC_MESSAGES = 'C'
LC_MONETARY = 'C'
LC_NUMERIC = 'C'
LC_TIME = 'C'
Might be worth checking the release notes on the website to see if there's
anything mentioned.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, krjg@devo.se
Subject: Re: Sort order with spaces?
In-Reply-To: <200309171450.30382.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox