po 5. 10. 2020 v 11:46 odesílatel Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> napsal:
> On 2020-09-29 08:23, Pavel Stehule wrote:
> > This was an important issue if I remember well. Passing mandatory NULL
> > as OUT arguments solves this issue.
> > I fully agree so OUT arguments are part
On 2020-09-29 08:23, Pavel Stehule wrote:
This was an important issue if I remember well. Passing mandatory NULL
as OUT arguments solves this issue.
I fully agree so OUT arguments are part of the procedure's signature.
Unfortunately, there is another difference
from functions, but I don't think
po 28. 9. 2020 v 18:43 odesílatel Andrew Dunstan <
andrew.duns...@2ndquadrant.com> napsal:
>
> On 8/27/20 4:34 AM, Peter Eisentraut wrote:
> > Procedures currently don't allow OUT parameters. The reason for this
> > is that at the time procedures were added (PG11), some of the details
> > of how
On 8/27/20 4:34 AM, Peter Eisentraut wrote:
> Procedures currently don't allow OUT parameters. The reason for this
> is that at the time procedures were added (PG11), some of the details
> of how this should work were unclear and the issue was postponed. I
> am now intending to resolve this.
>
>
On Fri, Aug 28, 2020 at 2:04 AM Peter Eisentraut
wrote:
> The handling of results of SQL statements executed at the top level
> (a.k.a. direct SQL) is implementation-specific and varies widely in
> practice. More interesting in practice, in terms of functionality and
> also compatibility, are nes
On 2020-08-27 15:56, Robert Haas wrote:
On Thu, Aug 27, 2020 at 4:34 AM Peter Eisentraut
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)
On Thu, Aug 27, 2020 at 4:34 AM Peter Eisentraut
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
emote DBA, Training & Services
From 27aa494f2f538d8d267841d5bd524b0eb3c77adb Mon Sep 17 00:00:00 2001
From: Peter Eisentraut
Date: Wed, 26 Aug 2020 23:11:55 +0200
Subject: [PATCH v1] Support for OUT parameters in procedures
Unlike for functions, OUT parameters for procedures are part of the
signature
