Re: how to pass an array to the plpgsql function from Java Code

On Mar 4, 11:34 am, sandeepkumar(dot)jakkar(dot)(dot)(dot)(at)gmail(dot)com ("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[?,?,?]) ");

pre.setArray(1,ar[0]);
pre.setArray(2,ar[1]);
pre.setArray(3,ar[2]);