Re: [web2py] Re: Postgresql query using trgm-indexing (fuzzy search option)

2011-12-08 Thread Johann Spies
On 8 December 2011 16:23, Massimo Di Pierro wrote: > What's similarity? It is an indication of the probability of the match. > What database engine supports it > Postgresql. See http://stackoverflow.com/questions/2254999/similarity-function-in-postgres-with-pg-trgm There is also http://www.

[web2py] Re: Postgresql query using trgm-indexing (fuzzy search option)

2011-12-08 Thread Massimo Di Pierro
What's similarity? What database engine supports it? On Dec 8, 4:02 am, Johann Spies 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 > us2