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[?,?,?]) "); pre.setArray(1,ar[0]); pre.setArray(2,ar[1]); pre.setArray(3,ar[2]); ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings