HI David,
Sorry I made typo error while logging the bug.
I executed this test script
CREATE FUNCTION mleast(VARIADIC arr numeric[]) RETURNS numeric AS $$
SELECT min($1[i]) FROM generate_subscripts($1, 1) g(i);
$$ LANGUAGE SQL;
Then
I executed a test retrieve query as
select distinct pa.parameter_mode
from information_schema.parameters as pa
o/p
"OUT"
"IN"
Example 2
I executed a test retrieve query as
select distinct pa.parameter_mode
from information_schema.parameters as pa
where pa.parameter_mode = 'VARIADIC'
o/p
Empty result set
I believed if other parameter modes are getting retrieved in the o.p same way ‘VARIADIC’ should be retrieved which is not the case.
So I believe it to be bug or partial implementation of the parameter_mode feature
Please let me know your comments
Regards,
Prajval Poojari
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Tuesday, February 14, 2017 4:58 PM
To: Prajval Poojari <ppoojari@erwin.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #14545: Unable to retrieve parameter mode 'VARIADIC'
The following bug has been logged on the website:
Bug reference: 14545
Logged by: Prajval Poojari
Email address: ppoojari@erwin.com
PostgreSQL version: 9.5.6
Operating system: Windows 10 Pro
Description:
Hi
i ran a simple select query as
"select pa.parameter_mode from information_schema as pa where
pa.parameter_mode = 'VARIADIC' "
and the DB returned me a null list.
I had already created a function with the parameter mode as VARIADIC.
Just wondering if there is some other specific way to retrieve this mode.
I just get an error when I try that - I think you are missing the "parameters" table specification.
CREATE FUNCTION variadictest(VARIADIC vargs text[])
# select data_type from information_schema.parameters WHERE specific_name ~ 'variadictest';
While imperfect locating any ARRAY data_type argument positioned last would be accurate if potentially imprecise (i.e., possible false positives).
There may be (probably is) a PostgreSQL-specific catalog that will contain the desired level of detail. Information Schema is "least common denominator" in nature which may explain the lack of specificity here.