Horton

BUG #2309: Wrong string comparison

Yury Don <yura@vpcit.ru>

View thread
From: "Yury Don" <yura@vpcit.ru>
To: pgsql-bugs@postgresql.org
Date: 2006-03-09T14:00:53Z
Lists: pgsql-bugs 
The following bug has been logged online:

Bug reference:      2309
Logged by:          Yury Don
Email address:      yura@vpcit.ru
PostgreSQL version: 8.1.3
Operating system:   Linux (Debian)
Description:        Wrong string comparison
Details: 

Looks like string comparison operators ignore spaces isnside of string.
Because of this sorting on text fields is wrong.

mdb=# select 'a z'::text>'ad'::text;
 ?column?
----------
 t