Re: array iteration?

Hey, that's cool. When did those functions arrive?

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
>