On Fri, 2001-11-23 at 11:24, [EMAIL PROTECTED] wrote: > now the sql command: select mit_id from table order by mit_id > should select all rows odered as the ABC. f.e.:123456789ABCD...QRST....etc. > At the range of 00000000000000C0...00000000000000CZ it goes creazy: > .... > 00000000000000CP > 00000000000000CQ > 00000000000000CR > 00000000000000CT > 00000000000000CU > 00000000000000CV > 00000000000000CW > 00000000000000CX > 00000000000000CY > 00000000000000CS > 00000000000000CZ > 00000000000000D0 > ... > (The CS value after the CY?????) Before, and after it goes "normal", only at this > interval goes mad. I've tried Postgresql 7.0, and 7.1.3 the bug still exist under >Red Hat 7.1 in two different machines. I've tested under cygwin, there is NO SUCH BUG! > At request I can send you the Database backup...
recreating the index on mit_id could help. Markus Bertheau
msg03104/pgp00000.pgp
Description: PGP signature
