X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 0A3F3310F2E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  2 Jul 2003 11:33:24 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 47689-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  2 Jul 2003 08:33:13 -0300 (ADT)
Received: from mail.SC-Networks.de (unknown [213.131.194.65])
	by svr1.postgresql.org (Postfix) with ESMTP id E92E8310F1D
	for <pgsql-sql@postgresql.org>; Wed,  2 Jul 2003 08:33:12 -0300 (ADT)
Received: from irrgang by mail.SC-Networks.de with local (Exim 3.34 #1)
	id 19Xfr6-0008KW-00
	for pgsql-sql@postgresql.org; Wed, 02 Jul 2003 13:32:56 +0200
Date: Wed, 2 Jul 2003 13:32:56 +0200
From: g.o.d@zefix.tv
To: pgsql-sql@postgresql.org
Subject: Weird order problem (ignoring whitespaces?)
Message-ID: <20030702113256.GB15132@sfear.sc-networks.de>
Reply-To: g.o.d@zefix.tv
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4.1i
X-Archive-Number: 200307/44
X-Sequence-Number: 14158

Hello,

I used to run a program on a box with postgres 7.1
There was data like:
'abc  234'
'abc 1234'

(not the extra blank before 234)

so after a select * from x order by field i got
'abc  234'
'abc 1234'

but since this program runs on a 7.3 postgres version
i get.

'abc 1234'
'abc  234'

it seems that postgres ignores the blank.

What can i do to get it work again?

Thanx,
Heiko Irrgang