I've recently converted a database to use bigint for the indices. Suddenly simple queries like
select * from new_test_result where parent_id = 2
are doing full table scans instead of using the index.
This is fixed in CVS HEAD. In the mean time, you can enclose the integer literal in single quotes, or explicitely cast it to the type of the column.
FWIW, this is an FAQ.
-Neil
---------------------------(end of broadcast)--------------------------- TIP 3: 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