I\'m looking for a way to emulate something like SELECT * FROM table WHERE attr LIKE \'%text%\' using a tsvector in PostgreSQL.
(All this was done with PostgreSQL 9.0.1 on Ubuntu 10.04, FWIW.) I\'ve tried writing my own lexize function for PostgreSQL specifically for names, based on the double metaphone algorithm. To produce
I\'m currently running a Rails migration where I am adding a datatype specific to Postgres, the tsvector.It holds search information in the form that Postgres expects for its built-in text searching c
I\'ve got a tsvector column in a table and I would like to be able to remove a lexeme from the tsvector.
I\'m considering adding a tsvector column to an existing table that will hold possible search terms fo开发者_开发百科r multiple columns in that same table (e.g. the tsvector column will equal to_tsvec
加载中,请稍侯......