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

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: How to create tsvector_update_trigger on Non-character type data
Дата
Msg-id BFEF381C-7D11-4216-AEF3-F1843D8ED869@thebuild.com
обсуждение исходный текст
Ответ на How to create tsvector_update_trigger on Non-character type data  (Gaini Rajeshwar <raja.rajeshwar2006@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Cannot start the postgres service
Следующее
От: Paul Hartley
Дата:
Сообщение: different sort order for primary key index