Re: Prepare Statement

Jie Liang wrote:
> Nope, it will get same error msg:
> Myfunction(text) does net exist

Hm, indeed. I just looked at the code and the plain setObject() path
seems slightly broken: it always passes PG_TEXT, not the PGobject's type.

However, the setObject variant that takes a target SQL type seems ok.
Try this:

>    stmt.setObject(1, obj, Types.OTHER);

-O