X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6BB4DD1B506 for ; Wed, 17 Sep 2003 13:51:00 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 09487-07 for ; Wed, 17 Sep 2003 10:50:33 -0300 (ADT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id B0D49D1B50F for ; Wed, 17 Sep 2003 10:50:28 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 19zchU-000GB3-0X; Wed, 17 Sep 2003 14:50:32 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id A1BFB16827; Wed, 17 Sep 2003 14:50:31 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id EE11D15930; Wed, 17 Sep 2003 14:50:30 +0100 (BST) From: Richard Huxton To: Kristian =?iso-8859-1?q?J=F6rg?= Subject: Re: Sort order with spaces? Date: Wed, 17 Sep 2003 14:50:30 +0100 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <3F682DB3.6080905@devo.se> <3F6853E4.3000604@devo.se> <3F685600.3010606@devo.se> In-Reply-To: <3F685600.3010606@devo.se> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200309171450.30382.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/157 X-Sequence-Number: 15135 On Wednesday 17 September 2003 13:39, Kristian J=F6rg wrote: > Kristian J=F6rg 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>=3D 'LU' order by normtext; richtest=3D# select * from foo order by b; a | b ---+----------- 1 | LUNDGREN 2 | M L R 3 | MACDOWELL 4 | MUSCLE (4 rows) LC_MESSAGES =3D 'C' LC_MONETARY =3D 'C' LC_NUMERIC =3D 'C' LC_TIME =3D 'C' Might be worth checking the release notes on the website to see if there's= =20 anything mentioned. --=20 Richard Huxton Archonet Ltd