On 7 June 2017 at 01:01, Josh Berkus <josh(at)berkus(dot)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?
--
greg