On Mar 4, 11:34 am, [EMAIL PROTECTED] ("Sandeep Kumar
Jakkaraju") wrote:
> how to pass an array to the plpgsql function from Java Code ??
If nothing else, you could use the ARRAY[] constructor:
int [] ar = {1,2,3};
PreparedStament pre= connection.prepareStatement( " select
test(ARRAY[?,?,?]) ");
how to pass an array to the plpgsql function from Java Code ??
say from a JDBC preparedStatement
Example :-
create or replace function test( x integer[] ) returns integer as
$BODY$
BEGIN
RETURN x[0];
END ;
language 'plpgsql'
JDBC CODE :-
int [] ar = {1,2,3};
PreparedStament pre= connec
