array iteration?

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: array iteration?
Date: 2003-11-22 20:44:43
Message-ID: 20031122204443.29965.qmail@web40609.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to iterate over an array in plpgsql?
Something like:

function insert_stuff (rel_ids int[])
...

foreach rel_ids as id
insert into table (rel_id, val)
values (id, 5);

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2003-11-22 21:03:02 Re: array iteration?
Previous Message Patrick Hatcher 2003-11-22 20:20:18 error loading shared libraries: libpq.so.3