Postgres Pro
Downloads
Home   >   mailing lists

new stored procedure with OUT parameters - Mailing list pgsql-general

From Anton Shen
Subject new stored procedure with OUT parameters
Date
Msg-id CA+4BxBwBHmDkSpgvnfG_Ps1SEeYhDRuLpr1AvdbUwFh-otTg8A@mail.gmail.com
Whole thread Raw
Responses Re: new stored procedure with OUT parameters  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
Hi all,

I was playing around with the stored procedure support in v11 and found that pure OUT parameters are not supported. Is there any reason we only support INOUT but not OUT parameters?

psql (11.0 (Homebrew petere/postgresql))
dev=# CREATE PROCEDURE test_sp(a OUT int) LANGUAGE plpgsql AS $$
dev$# BEGIN
dev$# a = 5;
dev$# END; $$;
ERROR:  procedures cannot have OUT arguments
HINT:  INOUT arguments are permitted.

Thanks,
Anton

pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: Re: What is the tuplestore?
Next
From: ramsiddu007
Date:
Subject: Newly Created Source DB Table Not Reflecting into Destination Foreign Tables