4 ms·
I have thought about expression indexes, and for expressions I need (@> on jsonb) they can't be used.
by murkt 6y ago
I have thought about expression indexes, and for expressions I need (@> on jsonb) they can't be used.
- asah 6y agoCan you wrap that operator call in a function, and index the output of that function? (sorry if dumb q - but I've used this technique myself, and indeed, my favorite hack in recent years are JavaScript UDFs in plv8... super ugly but very very flexible...)
- murkt 6y agoI'm not sure I can, and I definitely do not want to do that. I'm happy with a separate table and `btree` index on it.