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?