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