Explicit typing of numeric types - Mailing list pgsql-jdbc

Guys,

After a painful experience with int8 indices not being used for:

SELECT * FROM foo WHERE id = 1;

...since 1 is an int4 not an int8, I'm wondering if there would be
anything wrong with making the JDBC driver always put out explicit type
declarations?

Eg, setLong emitting 1 :: int8. setString emitting 'foo' :: text. Etc.
Whaddyathink?

ABS

--
Alaric B. Snell, Developer
abs@frontwire.com