new stored procedure with OUT parameters

From: Anton Shen <4175george(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: new stored procedure with OUT parameters
Date: 2018-12-11 06:19:51
Message-ID: CA+4BxBwBHmDkSpgvnfG_Ps1SEeYhDRuLpr1AvdbUwFh-otTg8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ramsiddu007 2018-12-11 09:44:39 Newly Created Source DB Table Not Reflecting into Destination Foreign Tables
Previous Message Hans Schou 2018-12-11 05:48:25 Re: What is the tuplestore?