Temp method sort question

[Ruslan Zasukhin]

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

Hi Jon,
 
> Another issue arose when considering the IFNULL sort I need to do.
> 
> All my fields are indexedbywords, so I have methods for sorting.
> 
> This query
> 
> select *,theDateSortMethod,COALESCE(authors,editors,title) as 'ff'
> from thereferences where hit>0 ORDER BY ff,theDateSortMethod
> 
> (when it works) will sort by ff, which is the field, not the sort
> method. Is this, then, the correct query
> 
> SELECT
>  
> *,theDateSortMethod,COALESCE(authorsSortMethod,editorsSortMethod,titleSortMeth
> od) 
> as 'ff'
> FROM
>     thereferences
> WHERE
>     hit>0 ORDER BY ff,theDateSortMethod

You mean that Methods do not have flag fIndexByWords ?

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.

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