Re: Supporting $n parameters in new syntax

2021-05-18 Thread Paul A Jungwirth
On Tue, May 18, 2021 at 3:00 PM Paul A Jungwirth wrote: > > I suspect I'm missing something in the > analyze/rewriting phase, because I get this error: > > ERROR: no value found for parameter 1 > . . . > > I was hoping that transformExpr would do everything I need re > identifying parameters, but

Supporting $n parameters in new syntax

2021-05-18 Thread Paul A Jungwirth
Hello hackers, I'm wrapping up a patch that adds SQL:2011 FOR PORTION OF syntax and then uses it to implement CASCADE in temporal foreign keys. The FKs are implemented as triggers, like ordinary FKs, and the trigger function makes a call through SPI that does `UPDATE %s FOR PORTION OF %s FROM $%d