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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
