From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | John Lister <john(dot)lister-ps(at)kickstone(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Array passing |
Date: | 2009-04-07 15:17:27 |
Message-ID: | 491f66a50904070817o3af217d4odc32bdfd29b47789@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Tue, Apr 7, 2009 at 10:24 AM, John Lister
<john(dot)lister-ps(at)kickstone(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Cottenceau | 2009-04-07 15:37:30 | Re: JAVA-POSTGRESQL connection broken |
Previous Message | Thomas Kellerer | 2009-04-07 14:39:06 | Re: BLOB help - yes I've read around! |