Horton

Re: BUG #14463: refcursor cann't used with array or variadic parameter?

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: 德哥 <digoal@126.com>, "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2016-12-13T16:45:31Z
Lists: pgsql-bugs 
Pavel Stehule <pavel.stehule@gmail.com> writes:
> It is not a bug - it is feature. PLpgSQL statements doesn't expect a
> expression on some places.

Well, it's not unreasonable to expect that a subscripted datum could
be used.  It looks to me like this is a grammar omission and the
executor code would work fine.

			regards, tom lane

Commits

  1. Improve handling of array elements as getdiag_targets and cursor_variables.