AW: AW: Combining cursors

[Barney]

I might be referring to the same thing here ?

But, something I have regularly found myself wanting to do
is to be able to search a cursor using SQL with the result being
a second cursor.

This would be really handy very often !

Barney






on 12/2/03 2:08 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> on 12/1/03 2:08 PM, Florian Bogeschdorfer at fb at memedia.de wrote:
> 
>>> Your talk about
>>> 
>>>     curs = curs1.Union( curs2 )
>>>     curs = curs1.Intersect( curs2 )
>>>     curs = curs1.Except( curs2 )
>>> 
>>> I wonder, if you really will need on cursor level, If this
>>> will be implemented in SQL ?
>> 
>> 1. More speed I guess
>> 
>> 2. more comfortable (at least for me)
>> 
>> 3. Easier, much easier, for those who newbies to SQL
>> 
>> 4. You can combine cursors where you kept no log about the queries
>> 
>> 5. Having a large cursor where you want to except a small cursor, that is
>> frequently updated - again: speed?
> 
> Agree!
> 
>> 6. I would like it very much...maybe others too
> 
> Okay, we will add this API into 2.0
>