Re: [Gnumed-devel] sort drugs by frequency of use

[Vaibhav Banait]

                        data,
                        field_label,
                        list_label,
                        rank
                FROM ((
                        -- substance intakes which match are first
                        SELECT
                                pk_substance AS data,
                                (description || ' ' || amount || ' ' || unit) 
AS field_label,
                                (description || ' ' || amount || ' ' || unit || 
' (in use)') AS list_label,
            
--------------------------
To this if we add durations and frequency , will it help autocomplete? 
Vaibhav 

Vaibhav Banait