On 10/18/07, Pavel Stehule <[EMAIL PROTECTED]> wrote: > this function can help with array's iteration. > > create function generate_iterator(anyarray) > returns setof integer > as $$ > select i > from generate_series(array_lower($1,1), > array_upper($1,1)) g(i) > $$ language sql;
There was a very similar proposal a little while back (google: array_to_set). I think I like those names better since you are returning a set, not an iterator :-). Also, this should be internal as you suggest (there is an undocumented builtin that already does this, _pg_expandarray). merlin ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly