Re: array iteration? - Mailing list pgsql-general

From Ben
Subject Re: array iteration?
Date
Msg-id 1069534981.1639.368.camel@purple
Whole thread Raw
In response to array iteration?  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: array iteration?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Yep.

http://archives.postgresql.org/pgsql-general/2003-11/msg00852.php

On Sat, 2003-11-22 at 12:44, CSN wrote:
> 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/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-general by date:

Previous
From: CSN
Date:
Subject: array iteration?
Next
From: Martin Marques
Date:
Subject: Re: error loading shared libraries: libpq.so.3