Re: Projection pushdown to index access method

2023-09-19 Thread Tom Lane
Robert Haas writes: > On Tue, Sep 19, 2023 at 12:35 PM Chris Cleveland > wrote: >> I'm working on an index access method. I have a function which can appear in >> a projection list which should be evaluated by the access method itself. >> Example: >> ... >> How do I get the system to pull the v

Re: Projection pushdown to index access method

2023-09-19 Thread Robert Haas
On Tue, Sep 19, 2023 at 12:35 PM Chris Cleveland wrote: > I'm working on an index access method. I have a function which can appear in > a projection list which should be evaluated by the access method itself. > Example: > > SELECT title, my_special_function(body) > FROM books > WHERE book_id <=

Projection pushdown to index access method

2023-09-19 Thread Chris Cleveland
I'm working on an index access method. I have a function which can appear in a projection list which should be evaluated by the access method itself. Example: SELECT title, my_special_function(body) FROM books WHERE book_id <===> 42; "<===>" is the operator that invokes the access method. The val