Home > mailing lists

Re: [NOVICE] PQprepare & Stored Proces & OUT parameters - Mailing list pgsql-novice

From	David G. Johnston
Subject	Re: [NOVICE] PQprepare & Stored Proces & OUT parameters
Date	October 18, 2017 22:26:02
Msg-id	CAKFQuwZksd+WM3nbxUd2zdxM0qr235kbN5T0YhWHkDsLBdsn=w@mail.gmail.com Whole thread Raw
In response to	[NOVICE] PQprepare & Stored Proces & OUT parameters (Ruslan R. Laishev <zator@yandex.ru>)
List	pgsql-novice

On Wed, Oct 18, 2017 at 9:01 AM, Ruslan R. Laishev <zator@yandex.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.

From: Ruslan R. Laishev
Date: 18 October 2017, 22:01:59
Subject: [NOVICE] PQprepare & Stored Proces & OUT parameters

From: Ruslan R. Laishev
Date: 20 October 2017, 15:03:09
Subject: [NOVICE] Fwd: PQprepare & Stored Proces & OUT parameters - Volume II