Re: facing problem in outparameters in c

On Wed, 2020-10-28 at 04:57 +0000, Mahesh Bodepati wrote:
> Actually i am calling a postgres function by using c language which description
> is defined in database side .when iam calling a postgres function by passing input
> and output parameters after excution of function in database side i need output
> data in correcsponding output parameters but iam not getting output like that.

Right; output parameters in a function are columns in the result set.

> i am getting total output data in response pointer.if iam getting total data
> in response pointer it is hard to figure out which data is for which output parameter.

No, that is very simple. You can call PQfnumber on the result set to find which
position in the result set belongs to a certain parameter name.

See https://www.postgresql.org/docs/current/libpq-exec.html#LIBPQ-EXEC-SELECT-INFO

> can you please check once attached two text files.

I looked, and the C code is unreadable.
You seem to be mixing embedded SQL and libpq calls, which you shouldn't.
There is great value in a consistent indentation style.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com