Temp method sort question
jda
jda at his.com
Tue Mar 15 14:12:20 CST 2005
> 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
>
>--
That's great. Now, if regular indexedbywords fields behaved this way
(#58) there would be no need for sort methods at all! :-)
Jon
More information about the Valentina-beta
mailing list