Allow USING and INTO clauses of plpgsql's EXECUTE to appear in either order.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: affcd50e4090a420fb235b11af007ca3f9ccf967
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2010-08-19T18:58:11Z
Releases: 8.4.5
Allow USING and INTO clauses of plpgsql's EXECUTE to appear in either order.

Aside from being more forgiving, this prevents a rather surprising misbehavior
when the "wrong" order was used: the old code didn't throw a syntax error,
but absorbed the INTO clause into the last USING expression, which then did
strange things downstream.

Intentionally not changing the documentation; we'll continue to advertise
only the "standard" clause order.

Backpatch to 8.4, where the USING clause was added to EXECUTE.

Files

PathChange+/−
src/pl/plpgsql/src/gram.y modified +34 −19