Re: unnest

On Nov 5, 2004, at 7:09 AM, John Hansen wrote:

> Attached, array -> rows iterator.
>
> select * from unnest(array[1,2,3,4,5]);

This is really handy!  But there is a problem...

> The switch statement could probably be done in a different way, but
> there doesn't seem to be any good examples of how to return anyitem. If
> anyone have a better way, please let me know.

Why do you need the switch statement at all? array->elements is already 
an array of Datums.  Won't simply returningarray->elements[array->i]
work?

The problem is:
test=# select * from unnest('{1,2,3,4,5}'::int8[]);  unnest
---------- 25314880 25314888 25314896 25314904 25314912
(5 rows)

Whereas simply returning the current Datum in array->elements returns 
the correct result:
    if (array->i < array->num_elements)SRF_RETURN_NEXT(funcctx,array->elements[array->i++]);    else
SRF_RETURN_DONE(funcctx);

test=# select * from unnest('{1,2,3,4,5}'::int8[]); unnest
--------      1      2      3      4      5
(5 rows)

Also works for the few other datatypes I checked.

Am I missing something obvious?

eric