News for hackers. Stuff that matters.

A comment on JIT-Compiling SQL Queries in PostgreSQL Using LLVM. Parent comment

Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM by asah on Monday February 22, 2021 @11:54AM (#26226737)
Can 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...)

[ Parent | on HN ]
Re:JIT-Compiling SQL Queries in PostgreSQL Using LLVM by murkt on Tuesday February 23, 2021 @06:04AM (#26235927)
I'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.
[ Parent | on HN ]