Re: How to create tsvector_update_trigger on Non-character type data

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: "pgsql-general(at)postgresql(dot)org mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to create tsvector_update_trigger on Non-character type data
Date: 2009-10-14 06:45:28
Message-ID: BFEF381C-7D11-4216-AEF3-F1843D8ED869@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)thebuild(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Hartley 2009-10-14 07:12:44 different sort order for primary key index
Previous Message Scott Marlowe 2009-10-14 06:29:44 Re: Cannot start the postgres service