Re: Support for OUT parameters in procedures - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Support for OUT parameters in procedures
Date
Msg-id CA+TgmobV5QdvDq7LJbRYULi9U7dUQnYz8MzhVmgMrDUmEUV4VQ@mail.gmail.com
Whole thread Raw
In response to Support for OUT parameters in procedures  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Support for OUT parameters in procedures
List pgsql-hackers
On Thu, Aug 27, 2020 at 4:34 AM Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> For a top-level direct call, you can pass whatever you want, since all
> OUT parameters are presented as initially NULL to the procedure code.
> So you could just pass NULL, as in CALL test_proc(5, NULL).

Is that actually how other systems work? I would think that people
would expect to pass, say, a package variable, and expect that it will
get updated.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach)
Next
From: Tom Lane
Date:
Subject: Re: factorial function/phase out postfix operators?