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).


---------------------------(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

Reply via email to