Postgres Pro
Downloads
Home   >   mailing lists

tsvector work with citext - Mailing list pgsql-hackers

From David E. Wheeler
Subject tsvector work with citext
Date
Msg-id EA8346F9-8F64-4837-ABE1-B383AF36E0DC@kineticode.com
Whole thread Raw
Responses Re: tsvector work with citext  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hey Hackers,

Is there a way to get tsvector_update_trigger() to work with citext columns? The attached case throws an error:

    ERROR:  column "title" is not of a character type

Is the fact that citext is a (non-preferred) member of the string category not sufficient for this to work? If not, are
thereany workarounds? 

Thanks,

David
Attachment

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pg_resetxlog sentences
Next
From: Thomas Munro
Date:
Subject: Obsolete use of volatile in walsender.c, walreceiver.c, walreceiverfuncs.c?