Re: PQprepare & Stored Proces & OUT parameters

On Wed, Oct 18, 2017 at 9:01 AM, Ruslan R. Laishev <zator(at)yandex(dot)ru> wrote:

> No errors if p_stv and p_msg has been declared as IN. So , what I'm need
> to check ?
>

​Input parameters are parameters you have to provide when calling a
function.

SELECT * FROM func($1, $2, $3) is a function that has three input
parameters.​

CREATE OR REPLACE FUNCTION __z$z (
p_compid uuid,
out p_stv integer,
out p_msg text
)

Is a function that has one input parameter. It would be called like:
select p_stv, p_msg FROM func($1)

David J.