union

[Ruslan Zasukhin]

On 3/8/04 10:20 PM, "jda" <jda at his.com> wrote:

>>>  2. Concatenating cursors (you've explained to me already how to in
>>>  2.0) so that I can get the union and the intersection of multiple
>>>  cursors. This will be very cool.
>> 
>> We have UINON and INTERSECT on SQL level.
> 
> Good.
> 
>> 
>> I think we have not yet tests query on Cursor table.
>> Must not be big problems. Important just to assign name for that tmp table
>> to use it for future queries.
>> 
>> Although I still not very sure this is good way.
>> TMP table do not have indexes. It needs time to build them.
> 
> I wouldn't need indexes, just the ability to get unions/interestions
> and create a list that shows the fields I want.

Problem that union REQUIRE index and sort of tables-operands.

Ok, let's discuss this again little later.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------