[SQL] How to loop though an array plpgsql?

[Matthew Schumacher]

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