Re: array iteration?
От | Ben |
---|---|
Тема | Re: array iteration? |
Дата | |
Msg-id | Pine.LNX.4.44.0311231636021.7403-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: array iteration? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: array iteration?
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: