KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm looking for a way to emulate something like SELECT * FROM table WHERE attr LIKE '%text%' using a tsvector in PostgreSQL. I've created a tsvector attribute without using a dictionary. Now, a query like ... SELECT title FROM table WHERE title_tsv @@ plainto_tsquery('ph:*'); ... would return all titles like 'Physics', 'PHP', etc. But how can I create a query that returns all records where the title start with 'Zend Fram' (which should return for instance 'Zend Framework')? Of course, I could use something like: SELECT title FROM table WHERE title_tsv @@ to_tsquery('zend') AND title_tsv @@ to_tsquery('fram:*'); However, this seems a little awkward. So, the question is: is there a way to formulate the query given above using something like: SELECT title FROM table WHERE title_tsv @@ to_tsquery('zend fram:*');
Tags (comma-separated)
Save Edits
Cancel