Re: How to create tsvector_update_trigger on Non-character type data - Mailing list pgsql-general

From Christophe Pettus
Subject Re: How to create tsvector_update_trigger on Non-character type data
Date
Msg-id BFEF381C-7D11-4216-AEF3-F1843D8ED869@thebuild.com
Whole thread Raw
In response to How to create tsvector_update_trigger on Non-character type data  (Gaini Rajeshwar <raja.rajeshwar2006@gmail.com>)
List pgsql-general
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 you attempting to do?  Do you
want to index the text version of the doc_id field (for example, if
doc_id is 12345, you want to include the literal string "12345" in the
index), or is doc_id a key into another table, and you want to include
some text fields from that other table in the index?
--
-- Christophe Pettus
    xof@thebuild.com


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Cannot start the postgres service
Next
From: Paul Hartley
Date:
Subject: different sort order for primary key index