On Tue, Apr 7, 2009 at 10:24 AM, John Lister
<john.lister-ps@kickstone.com> wrote:
Hi, i've been playing with arrays using the 604 version JDBC 4 driver and i have a question. They seem to be converted to strings which are passed back and forth to the server.
Is it possible to configure the driver to pass the arrays in native form? The overhead of converting to strings is quite big in my case (both in the size of the string and the time taken) so would like to eliminate it if possible...
Which leads onto, does the postgresql protocol support native arrays? i'm trying to find docs about the datatypes but would hope it did...
Yes, it does, but there are platform specific binary representations of native types. For instance you can have floating point or integer datetimes.
There was some work done on supporting binary protocol at one point, not sure where it stands now.
Dave