Module: PsqlAutocomplete

Defined in:: lib/psql_autocomplete.rb,
lib/psql_autocomplete/version.rb

Overview

Helper mixin for generating autocomplete queries on the postgresql full text search engine

Constant Summary collapse

VERSION =

'0.1.1'

Instance Method Summary collapse

#autocomplete_query(sentence, fields) ⇒ Object

Returns a postgres FTS query injectable in a where clause.

Instance Method Details

#autocomplete_query(sentence, fields) ⇒ `Object`

Returns a postgres FTS query injectable in a where clause



7
8
9

# File 'lib/psql_autocomplete.rb', line 7

def autocomplete_query(sentence, fields)
  "(#{tsvector(fields)})::tsvector @@ $$#{tsquery(sentence)}$$::tsquery"
end