Re: Need assistance for running postgresql procedures

Thanks, I'll check it out.

Regards,
Sasmit Utkarsh
+91-7674022625

On Wed, 24 Jan, 2024, 01:59 Francisco Olarte, <folarte(at)peoplecall(dot)com>
wrote:

> Hi sasmit.
>
> On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh <utkarshsasmit(at)gmail(dot)com>
> wrote:
> > Kindly assist with the issue faced while calling procedures on
> postgresql using libpq in C. I have attached all the details in the note.
> Please let me know if you need any more information
>
> I'm not familiar with using binary parameters, but are you sured you
> do not need calling htonl(3) on the rtp value? ( 3 is man section, not
> htonl argument ).
>
> "Values passed in binary format require knowledge of the internal
> representation expected by the backend.
> ********* For example, integers must be passed in network byte order.
> ******
> Passing numeric values requires knowledge of the server storage
> format, as implemented in
> src/backend/utils/adt/numeric.c::numeric_send() and
> src/backend/utils/adt/numeric.c::numeric_recv()."
>
> A quick test would be to use rtp=0x04000000 and see if it then works (
> if it comes from cmd line or similar, if it comes from code just use
> hton )
>
>
> Francisco Olarte.
>