Thread: construct_array() use with PQexec with binary data

construct_array() use with PQexec with binary data

From
Kenneth Marshall
Date:
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


Re: construct_array() use with PQexec with binary data

From
Tom Lane
Date:
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