Re: Another feature request...

[email protected] (Adam Kennedy) Mon, 12 Dec 2005 15:36:31 +1100
Newsgroups perl.dbi2.dev
Message-ID <[email protected]>
>> > Does that explain much, or would something "practical" be better?
>>I would be interested in a real example of where this is useful. I'd 
>>also like to know if any database in existance supports this, or plans to.
> 
> 
> It is useful at least wherever lazy access to multiple result sets would
> be useful.  To be honest co-routines are one of those things that until
> you see how simple they make some problems, you don't understand why
> they are useful.

Right... hence why I'd like to see one of these real examples :)

> Oracle seems to support multiple concurrent selects operating as if they
> were all read-only cursors.  Pg, etc, can support this behaviour with
> explicit cursors.

Would this be multiple selects against a single statement handler?