[pgadmin-support] IN argument keyword not needed

[Michal Kozusznik]

Hello
I found, that in case of functions which returns TABLE structure, 
function arguments are proceeded by IN keyword.
I believe it's because of similarity between 2 methods returning recordset:
- TABLE structure
and
- OUT arguments with conjunction of SETOF
Also please note, that arguments of function which has no OUT arguments 
at all, are no proceeded by IN keyword.

Suggestion: remove IN keywords from argument list in case the function 
is defined to return TABLE structure.

Examples:

Current state (pgAdmin v.1.20)

CREATE OR REPLACE FUNCTION some_function(IN some_arg INTEGER)
  RETURNS TABLE(some_columns....) AS
...


Suggested state:

CREATE OR REPLACE FUNCTION some_function(some_arg INTEGER)
  RETURNS TABLE(some_columns....) AS
...


with regards

<<attachment: kozusznik_michal.vcf>>-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support