Re: tightening up on use of oid 0 - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: tightening up on use of oid 0
Date
Msg-id Pine.BSO.4.56.0410080828180.2827@leary.csoft.net
Whole thread Raw
In response to tightening up on use of oid 0  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: tightening up on use of oid 0
List pgsql-jdbc

On Fri, 8 Oct 2004, Oliver Jowett wrote:
>
> Executing "SELECT foo(?)" via PreparedStatement will work fine if you
> pass a non-null PGline or PGbox argument to setObject, but if you try to
> setNull() then you will get ambiguity between the two functions at
> execution time.
>
> I can't see a way to fix this without a postgresql extension of some
> sort. Options I can think of are:

Can't the existing PGobject interface handle this.  You can create a
PGobject with the correct datatype and a null value and that should work.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Fix setArray() when using the v3 protocol (was Re: Postgres
Next
From: "Serguei A. Mokhov"
Date:
Subject: Re: Using gettext