On 7 June 2017 at 01:01, Josh Berkus <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
