Home > mailing lists

Using array in Functions plpgsql - Mailing list pgsql-novice

From	Benjamin RICHARD
Subject	Using array in Functions plpgsql
Date	April 17, 2003 12:37:16
Msg-id	004d01c304e6$78958580$3c02a8c0@mourmansk Whole thread Raw
List	pgsql-novice

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 for realizing dynamic insert query like this

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

Is it possible ?

Thanks

From: Ivicz László
Date: 17 April 2003, 07:37:23
Subject: Can I make a function an explicit transaction within?

From: Josh Berkus
Date: 17 April 2003, 17:39:33
Subject: Re: Can I make a function an explicit transaction within?