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