Duistere Pluizenbal on Nostr: nprofile1q…utslx Magic! That is, I wrote a matching function and assigned a support ...
nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpq0cq07ulfyc7y2l8rczk9s36g8j65tq3m6xk9us8hr3ua4ktfmaqqeutslx (nprofile…tslx) Magic!
That is, I wrote a matching function and assigned a support function to handle SupportRequestIndexCondition requests and generate an expression that turns the prefix match into a (x >= 'min' && x <= 'max'), which the btree index code can use for lookup.
The main challenge was finding out how to deal with the SQL expression AST in C, because that's carefully left out of the docs.
https://www.postgresql.org/docs/17/xfunc-optimization.html
That is, I wrote a matching function and assigned a support function to handle SupportRequestIndexCondition requests and generate an expression that turns the prefix match into a (x >= 'min' && x <= 'max'), which the btree index code can use for lookup.
The main challenge was finding out how to deal with the SQL expression AST in C, because that's carefully left out of the docs.
https://www.postgresql.org/docs/17/xfunc-optimization.html