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

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: 德哥 <digoal@126.com>, "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2016-12-13T16:49:18Z
Lists: pgsql-bugs
2016-12-13 17:45 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:

> 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.
>

There is only one possible issue - the early type check in compile time
will be moved to late check in runtime.

Maybe it was reason why somebody didn't allowed a expr there.

Regards

Pavel


>
>                         regards, tom lane
>

Commits

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