IN argument keyword not needed

From: Michal Kozusznik <kozusznik(dot)michal(at)ifortuna(dot)cz>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: IN argument keyword not needed
Date: 2015-08-11 14:57:26
Message-ID: 55CA0D56.2050401@ifortuna.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 Content-Type Size
kozusznik_michal.vcf text/x-vcard 370 bytes

Browse pgadmin-support by date

  From Date Subject
Next Message Alvaro Herrera 2015-08-11 16:26:22 Re: Fwd: Bug?
Previous Message Donald Kolafa 2015-08-08 01:49:44 HELP - you have disabled by Dell XPS 13 laptop