On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh <utkarshsasmit@gmail.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 )
