What's similarity? What database engine supports it?
On Dec 8, 4:02 am, Johann Spies <johann.sp...@gmail.com> wrote: > How would one translate the following query into DAL - or should I use > executesql (I would like to use the query in SQLFORM.grid): > > select B.title, A.title, similarity(A.title, B.title) > from > us2006_2010 B > left join akb_articles A on (A.title % B.title) > where > B.id in > (select A.id from us2006_2010 A > left join akb_articles B on A.ltitle = B.ltitle > where B.title is null) > order by similarity desc > > The shortened result looks like this: > > B.title1 | A.title1 | 0.960526 > B.title2 | A.title2 | 0.905263 > B.title1 | A.title3 | 0.511905 > ... > > Johann Spies > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3)
