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? -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers