Home > mailing lists

Thread: Using array parameter in Functions plpgsql

Using array parameter in Functions plpgsql

From

"Benjamin RICHARD"

Date:

17 April 2003, 13:27:51

Hi,

I'm trying to use array in a function but it seems to be a little bit harder than i thought.

So i have a function with 2 parameters 'INTEGER[]' and 'INTEGER'

in this function i would like to loop in the array ($1) to realize dynamic insert query like this

LOOP

INSERT INTO myTable ($2 , current value of $1)

END LOOP

Is it possible ?

Thanks