Hi sasmit. On Tue, 23 Jan 2024 at 18:51, Sasmit Utkarsh <utkarshsas...@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 ) Francisco Olarte.
