On Oct 13, 2009, at 11:21 PM, Gaini Rajeshwar wrote:
doc_id -- Name of the column. It's data type is integer
The strict error message is correct: The full-text search feature of
PostgreSQL can only index text strings, and doc_id (as an integer) is
not a text string. What precisely are yo
Hi,
How can we create tsvector update trigger on Non-character data type.
For example, i have created a ts vector trigger something like this.
*CREATE TRIGGER tr_doc_id_col
BEFORE INSERT OR UPDATE
ON document
FOR EACH ROW
EXECUTE PROCEDURE tsvector_update_trigger('tsv_doc_id',
'pg_catalog.english'