Re: SupportRequestSimplify and SQL SRF

2020-03-18 Thread Ronan Dunklau
> Hm. There was never really any expectation that support functions > would be attached to PL functions --- since you have to write the > former in C, it seems a little odd for the supported function not > to also be C. Perhaps more to the point though, what simplification > knowledge is this sup

Re: SupportRequestSimplify and SQL SRF

2020-03-18 Thread Tom Lane
Ronan Dunklau writes: > What I want to do is to evaluate whether id = t1_id AND somecolumn is NOT > NULL at planification time, and replace the function by another one if this > can be pruned altogether. Hm. There was never really any expectation that support functions would be attached to PL fu

SupportRequestSimplify and SQL SRF

2020-03-18 Thread Ronan Dunklau
Hello, I've been trying to play with support functions for a use-case of ours, and found some behaviors I don't know are expected or not. The use case: we have some complicated queries, where whole-branches of the execution tree could be cut if some things were evaluated at planning time. Take th