Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2A400475921 for ; Thu, 19 Sep 2002 10:34:27 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id AF1FE4758E6 for ; Thu, 19 Sep 2002 10:34:26 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CA0CCD60A; Thu, 19 Sep 2002 07:34:27 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id BBA7C5C02; Thu, 19 Sep 2002 07:34:27 -0700 (PDT) Date: Thu, 19 Sep 2002 07:34:27 -0700 (PDT) From: Stephan Szabo To: =?iso-8859-1?Q?Thorbj=F6rn_Eriksson?= Cc: Subject: Re: Stripping white-space in SELECT statments In-Reply-To: Message-ID: <20020919072834.D27151-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/218 X-Sequence-Number: 9495 On Thu, 19 Sep 2002, [iso-8859-1] Thorbj=F6rn Eriksson wrote: > Hello, > > I've encountered a strange behavior in postgres 7.2.1 regarding how psql > handles strings ending with space characters. > What locale did you initdb with? Some locales on some systems have behavior like that. To test, you could try the unix sort command on data like: 201901 Z 201901-D 201901 D in the same locale and see what order you get (specifically where does that first line go - on my machine it goes to the end unless I explicitly choose a locale like "C")