On 06/09/2017 07:54 PM, Greg Stark wrote: > On 7 June 2017 at 01:01, Josh Berkus <j...@berkus.org> wrote: >> P3: apparently jsonb_to_tsvector with lang parameter isn't immutable? >> This means that it can't be used for indexing: >> >> libdata=# create index bookdata_fts on bookdata using gin (( >> to_tsvector('english',bookdata))); >> ERROR: functions in index expression must be marked IMMUTABLE > > I don't have a machine handy to check on but isn't this a strange > thing to do? Isn't there a GIN opclass on jsonb itself which would be > the default if you didn't have that to_tsvector() call -- and which > would also work properly with the jsonb operators? >
The above is the documented way to create an FTS index on a JSONB field. -- Josh Berkus Containers & Databases Oh My! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers