Re: Explicit typing of numeric types

From: Barry Lind <barry(at)xythos(dot)com>
To: "Alaric B(dot) Snell" <abs(at)frontwire(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Explicit typing of numeric types
Date: 2002-01-15 16:51:44
Message-ID: 3C445E20.6060105@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alaric B. Snell 2002-01-15 17:40:30 Re: Explicit typing of numeric types
Previous Message Bruce Momjian 2002-01-15 16:50:23 Re: [GENERAL] OT: anon CVS hassles