Re: Proposal: generate_iterator functions

On 10/18/07, Pavel Stehule <pavel.stehule@gmail.com> 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