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