On 2025-May-24, Sami Imseih wrote:
> therefore, a user supplied query like this:
> ```
> select where $5 in ($1, $2, $3) and $6 = $4 and 1 = 2
> ```
>
> will be normalized to:
> ```
> select where $1 in ($2 /*...*/) and $3 = $4 and $5 = $6
> ```
Hmm, interesting.
I think this renumbering should not be a problem in practice; users with
unordered parameters have little room to complain if the param numbers
change on query normalization. At least that's how it seems to me.
If renumbering everything in physical order makes the code simpler, then
I don't disagree.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"Puedes vivir sólo una vez, pero si lo haces bien, una vez es suficiente"