The following bug has been logged online: Bug reference: 4788 Logged by: Gerhard Kirchmann Email address: gerhard.kirchm...@arcor.de PostgreSQL version: 8.4beta1 Operating system: openSUSE 11.1 Description: bug in string comparison Details:
I have the same table in 8.3.7 and 8.4beta1 where one column (verein_id) contains the string "56022" in 47 rows out of about 93000 rows. Under 8.4beta1 I get only 45 rows with: where vereind_id = '56022' and with where verein_id like '56022%' I get all 47 rows. The length of the string is always five. I work with utf-8. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs