MSSQL has a great feature called Table Valued Parameters. It allows you to pass a table of a custom data to stored procedures and functions.

I was wondering what is the equivalent , if exists, in PostgreSQL, using JDBC? I know about the option of passing Arrays as a function parameters, but that seems limited to Postgresql data types.

Consider the following PL/pgSQL code:

CREATE  TYPE number_with_time AS(
_num   float,
_date  timestamp

and this function header:

CREATE OR REPLACE FUNCTION myfunc(arr number_with_time[])

Can anyone post a JAVA code using JDBC driver of calling that function with an array of the user defined data type?


Browse other questions tagged or ask your own question.