I'd like to do something like this:
select array_explode(array_col) from table1 where col2 = 'something';
where array_explode returns the elements of array_col unpacked onto
separate rows.
I tried creating a function returning a setof type, but postgresql
produces a "set-valued function called in context that cannot accept a
set" error. I've seen this error in the list archives, but I'm not sure
how to translate the simple cases discussed into this situation. I'm
sure it's something simple, but it's been eluding me.
Thanks,
Kevin Murphy