Return ordered list of near match items based on tag matches

offspinner () — Thu, 09 Feb 2006 21:41:00 GMT

// description of your code here



select t2.dbid, t2.tag, count(t2.dbid) as match_count from tags as t1, tags as t2 where t1.dbid = '105319' and t2.tag = t1.tag and t1.dbid != t2.dbid GROUP BY t2.dbid 1 ORDER BY match_count;

near? function

gregg.irwin (Gregg Irwin) — Tue, 10 Jan 2006 05:12:49 GMT



    near?: func [

        {Returns true if the values are <= 1E-15 apart.}

        value1 [number! money! time!]

        value2 [number! money! time!]

        /within  "Specify an alternate maximum difference (epsilon)."

            e [number! money! time!] "The epsilon value."

    ][

        e: abs any [e  to value1 1E-15]

        e >= abs value1 - value2

    ]

DZone Snippets: near code

Return ordered list of near match items based on tag matches

near? function