I need to loop though an input array, but can't figure out how to do it, the docs aren't really clear on this.
Something like this:
CREATE FUNCTION update (_id INTEGER[])
RETURNS VOID AS
$$
BEGIN
FOR i IN SELECT _id LOOP
INSERT INTO table VALUES (_id[i]);
END LOOP;
END;
$$
LANGUAGE plpgsql;
Anyone know the correct loop syntax?
schu
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
