It would be great to have support for this kind of thing:
SELECT * FROM team WHERE team.search_column @@ to_tsquery('new & york & yankees') ;
@@ is a conditional operator, which can be read as 'matches'. team.search_column is a tsvector and the right-hand item is a tsquery.
Documentation and more examples:
http://www.postgresql.org/docs/9.0/interactive/textsearch.html http://www.postgresql.org/docs/9.0/static/textsearch-intro.html http://www.postgresql.org/docs/9.0/interactive/functions-textsearch.html
This should be available on next release, 0.6.7
Log in to post a comment.
It would be great to have support for this kind of thing:
@@ is a conditional operator, which can be read as 'matches'. team.search_column is a tsvector and the right-hand item is a tsquery.
Documentation and more examples:
http://www.postgresql.org/docs/9.0/interactive/textsearch.html
http://www.postgresql.org/docs/9.0/static/textsearch-intro.html
http://www.postgresql.org/docs/9.0/interactive/functions-textsearch.html
This should be available on next release, 0.6.7