2011/8/8 Ondrej Ivanič :
> Hi,
>
> 2011/8/9 Merlin Moncure :
>> You have a few of different methods for passing sets between functions.
>
> I do not want to pass data between functions. The ideal solution
> should look like this:
> select * from my_map_func()
well, the method still applies: you'd
Hi,
2011/8/9 Merlin Moncure :
> You have a few of different methods for passing sets between functions.
I do not want to pass data between functions. The ideal solution
should look like this:
select * from my_map_func()
> 1) refcursor as David noted. reasonably fast. however, I find the
> 'FETC
2011/8/7 Ondrej Ivanič :
> Hi,
>
> It is possible to pass query result (or cursor?) as function
> parameter? I need a function which emits zero or more rows per input
> row (map function from map&reduce paradigm). Function returns record
> (or array): (value1, value2, value3)
> I've tried the follo
On Aug 7, 2011, at 23:24, Ondrej Ivanič wrote:
> Hi,
>
> It is possible to pass query result (or cursor?) as function
> parameter? I need a function which emits zero or more rows per input
> row (map function from map&reduce paradigm). Function returns record
> (or array): (value1, value2, value
Hi,
It is possible to pass query result (or cursor?) as function
parameter? I need a function which emits zero or more rows per input
row (map function from map&reduce paradigm). Function returns record
(or array): (value1, value2, value3)
I've tried the following:
1) create or replace function t
