Temp method sort question

[jda]

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

Jon