On 11/13/05, Nathan Kurz <[EMAIL PROTECTED]> wrote: > > On Sun, Nov 13, 2005 at 07:30:58AM -0500, [EMAIL PROTECTED] wrote: > Or even better, is there any way to write a user defined function that > could do the ordering and limiting internally to reduce the data set > early? I suppose I could do it as a aggregate function that returns a > text string and then reparse that into a second query using IN, but it > would wonderful if there was a way to 'explode' the return value of a > function into multiple rows. Something like:
If it calls the same user defined function twice sequentially perhaps you can cache the function result in ram, if you get the same parameters then return the same result the last call produced.
