How to loop though an array plpgsql? - Mailing list pgsql-sql

From Matthew Schumacher
Subject How to loop though an array plpgsql?
Date
Msg-id 42EABE20.6040805@aptalaska.net
Whole thread Raw
Responses Re: How to loop though an array plpgsql?
List pgsql-sql
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


pgsql-sql by date:

Previous
From: daq
Date:
Subject: Re: CREATE TABLE AS SELECT
Next
From: Kyle Bateman
Date:
Subject: bug in information_schema?