Weird order problem (ignoring whitespaces?)

From: g(dot)o(dot)d(at)zefix(dot)tv
To: pgsql-sql(at)postgresql(dot)org
Subject: Weird order problem (ignoring whitespaces?)
Date: 2003-07-02 11:32:56
Message-ID: 20030702113256.GB15132@sfear.sc-networks.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2003-07-03 11:19:17 Re: Inquiry From Form [pgsql]
Previous Message Együd Csaba 2003-07-02 10:39:28 Re: Postgres - Delphi Application