The following bug has been logged online:

Bug reference:      2309
Logged by:          Yury Don
Email address:      [EMAIL PROTECTED]
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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to