> explain analyze select * from connection_data where id=3D23457;
Quote the number or cast it to int8.
id=3D'23457' or id=3Dcast(23457 as int8)
PostgreSQL has a hard time with mixed datatypes and indexscans at the
moment.
--=20
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc