The following bug has been logged online:
Bug reference: 2309
Logged by: Yury Don
Email address: yura(at)vpcit(dot)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