Pavel Stehule <pavel.steh...@gmail.com> writes: > pá 12. 3. 2021 v 21:08 odesílatel Tom Lane <t...@sss.pgh.pa.us> napsal: >> I attach a v3 that I like better, although there's room to disagree >> about that.
> I am not sure if people can understand the "optimizable command" term. More > common categories are DML, DDL and SELECT. Maybe it is easier to say. DDL > statements don't support parametrizations, and then the variables cannot be > used there. Yeah, but DML/DDL is a pretty squishy separation as well, besides which it'd mislead people for cases such as CREATE TABLE AS SELECT. (Admittedly, I didn't mention that in my version either, but if you think in terms of whether the optimizer will be applied then you will draw the right conclusion.) Maybe there's no way out but to specifically list the statement types we can insert query parameters in. regards, tom lane