construct_array() use with PQexec with binary data

Started by Kenneth Marshallover 15 years ago2 messages
#1Kenneth Marshall
ktm@rice.edu

Dear PostgreSQL development community,

I am working on adapting a regular PQexec() call to use binary
transmission of the parameters. One of the parameters is an
array of BIGINT. Looking in include/utils/array.h, it appears
that construct_array() will do exactly what I need to get an
array to pass in with the PQexec() call. Is there a library
that includes that functionality? Or do I need to cobble it
together from the various pieces of code? Thank you for any
help.

Regards,
Ken

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Kenneth Marshall (#1)
Re: construct_array() use with PQexec with binary data

Kenneth Marshall <ktm@rice.edu> writes:

I am working on adapting a regular PQexec() call to use binary
transmission of the parameters. One of the parameters is an
array of BIGINT. Looking in include/utils/array.h, it appears
that construct_array() will do exactly what I need to get an
array to pass in with the PQexec() call. Is there a library
that includes that functionality? Or do I need to cobble it
together from the various pieces of code? Thank you for any
help.

libpq does not provide any functionality for manipulating binary
data --- it just sends and receives it. You might care to look at
http://libpqtypes.esilo.com/
which offers a lot of higher-level functionality in this area.

regards, tom lane