Merlin Moncure <mmonc...@gmail.com> writes: > We already have 'SET LOCAL', which manages scope to the current > transaction. How about SET BLOCK which would set until you've left > the current statement block?
(1) I do not think this approach will play terribly well in any of the PLs; their notions of statement blocks all differ from whatever we might think that is at the interactive-SQL-command level. (2) AIUI the feature request is specifically for a single-statement variable change, not any larger scope than that. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers