function to_tsquery(tsquery) does not exist

[riccardocagnasso]

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) function to_tsquery(tsquery) does not exist
LINE 6: ...r, '')) || coalesce(identity_4.search_vector)) @@ to_tsquery...

I get this error when searching a on a combined search vector like

        combined_search_vector = User.search_vector | func.coalesce(
            Person.search_vector, u'')

        query = query.outerjoin(Person).filter(combined_search_vector.match(
            func.tsq_parse(search_query)))

        return query

[riccardocagnasso]

I tracked the code. Long story short, you shouldn't use "match" but the provided "search" function with the vector parameter.

Ok, but you really should update the documentation mate.

[cgle]

query = query.filter(combined_search_vector.search(func.tsq_parse(term)))
I use this but it says:
'BinaryExpression' object nor 'comparator_factory' object has an attribute 'search'

[sonnybaker]

Resolution for anyone stuck with this:

search_query = 'test'
combined_search_vector = (Project.search_vector | db.func.coalesce(Document.search_vector, u''))

projects = (
    db.session.query(Project)
    .join(Document)
    .filter(
        combined_search_vector.match(search_query)
    )
)

[xenups]

actually, it doesn't need a long way just instead of using a filter use it this way:

search_query = 'test'
combined_search_vector = (Project.search_vector | db.func.coalesce(Document.search_vector, u''))
projects = db.session.query(Project)
found_items = search(search_query, combined_search_vector, projects)

the documentation needs to be update