Re: Explicit typing of numeric types - Mailing list pgsql-jdbc

Alaric,

This has been discussed before on this mail list and rejected.  Please
see the archives for the rationale.

thanks,
--Barry


Alaric B. Snell wrote:

> 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
>
>