Re: Calling functions with table-based-type parametars - Mailing list pgsql-jdbc

On Mon, 26 Feb 2007, Mario Splivalo wrote:

>> Why not conn.prepareCall("{call f1(ROW(?, ?)}") or
>> conn.prepareStatement("SELECT f1(ROW(?, ?))");
>
> When I try it like above (using conn.prepaleCall), i get this:
>
> 2007-02-26 16:58:19.004 CET [9592] <jura> SELECTERROR:  function
> f1(record) does not exist
> 2007-02-26 16:58:19.004 CET [9592] <jura> SELECTHINT:  No function
> matches the given name and argument types. You may need to add explicit
> type casts.

This is saying you need to write it with a cast from the row to the table
type:

conn.prepareCall("{call f1(ROW(?, ?)::t1)}")

Kris Jurka