Re: array iteration?

Ben wrote:
> Hey, that's cool. When did those functions arrive?

I think 7.4.  We had a lot of nice array stuff added.


>
> On Sun, 23 Nov 2003, Tom Lane wrote:
>
> > Ben <bench@silentmedia.com> writes:
> > > On Sat, 2003-11-22 at 12:44, CSN wrote:
> > >> Is it possible to iterate over an array in plpgsql?
> >
> > > Yep.
> > > http://archives.postgresql.org/pgsql-general/2003-11/msg00852.php
> >
> > The cited example is pretty iffy since it assumes that the valid array
> > entries are all > 0.  In recent PG version you can use the array_upper
> > and array_lower functions instead:
> >
> >     for i in array_lower(a,1) .. array_upper(a,1) loop
> >         -- do something with a[i]
> >     end loop;
> >
> >             regards, tom lane
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073