Explicit typing of numeric types

From: "Alaric B(dot) Snell" <abs(at)frontwire(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Explicit typing of numeric types
Date: 2002-01-15 10:42:30
Message-ID: Pine.LNX.4.43.0201151039550.2861-100000@calvin.frontwire.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)frontwire(dot)com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-01-15 13:37:17 Re: Problem with getImportedKeys / getExportedKeys
Previous Message Ryouichi Matsuda 2002-01-15 10:41:31 Re: Failure in timestamptz of JDBC of 7.2b4