Can you wrap that operator call in a function, and index the output of that func... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		asah on Feb 22, 2021 \| parent \| context \| favorite \| on: JIT-Compiling SQL Queries in PostgreSQL Using LLVM 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...)

murkt on Feb 23, 2021 [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact