Temp method sort question

[Ruslan Zasukhin]

On 3/15/05 5:05 PM, "jda" <jda at his.com> wrote:

>> You mean that Methods do not have flag fIndexByWords ?
> 
> That's right, they do not.
> 
>> 
>> Actually for SELECT expression this can be not important.
>> Because formed expressions will not have own flag.
>> And index for sorting will be built for this new column.
>> 
> 
> So to make sure, you mean
> 
>   select *,theDateSortMethod,COALESCE(authors,editors,title) as 'ff'
> from thereferences where hit>0 ORDER BY ff,theDateSortMethod
> 
> will sort properly even though authors, editors, and title are indexedbywords?

Yes.

And remind -- will be indexed/sorted the first 255 chars of text

-- 
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
-------------------------------------------------------------