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