Re: [BUGS] Comparison of Strings

2000-11-23 Thread Tom Lane
Mike Schulte <[EMAIL PROTECTED]> writes: > If I run the following command, I get [the string matches the first two > entries in the table]: > cs302=# select * from author where isbn = '1565921941'; > isbn | author > --+ > (0 rows) Ugh :-(. This looks like a corrupted-index problem

[BUGS] Comparison of Strings

2000-11-23 Thread Mike Schulte
I am running PostgreSQL 7.0.2 on sparc-sun-solaris2.8, compiled by gcc 2.95.2 I have a database table whose contents are cs302=# select * from author; isbn | author --+- '1565921941' | 'Meyer, Jon' '1565921941' | 'Downing, Troy' '0201