Re: Can PostgreSQL do data type automated casting in - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Can PostgreSQL do data type automated casting in
Date
Msg-id 6022BCB2-7A1B-47A2-AC85-CDBB7CBD127C@fastcrypt.com
Whole thread Raw
In response to Re: Can PostgreSQL do data type automated casting in  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Can PostgreSQL do data type automated casting in
List pgsql-jdbc
You're on fairly shaky ground using "allowed by the spec" as
justification. I'm thinking there are far more instances where people
expect Oid unspecified to work than
instances where they are going to change the type of the IN parameter
in the same statement.

Given that the default behaviour adheres to the spec, I'm not too
worried about the case below failing under these specific
circumstances. I presume it passes with the 8.0,8.1 behaviour.

Dave

On 24-Nov-05, at 3:47 PM, Oliver Jowett wrote:

> Dave Cramer wrote:
>
>> Looking at the test case is this a realistic situation ? Would
>> anyone  really want to change the types of a parameter of a
>> statement ?
>
> It's allowed by the spec as far as I can tell, so we need to
> support it.
>
> -O
>


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Why is bool == java.sql.Types.BIT ??
Next
From: Oliver Jowett
Date:
Subject: Re: Can PostgreSQL do data type automated casting in