On Sat, Apr 24, 2010 at 2:23 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
with huge emphasis on the word small.Well, you missed the most important part: not using cursors at all.
Instead of declaring a cursor and looping it to build the array, build
it with array(). That's what I've been saying: arrays can completely
displace both temp tables _and_ cursors when passing small sets around
functions.
--
GJ
