Skip site navigation (1) Skip section navigation (2)

Re: Array passing

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 (view raw or flat)
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

In response to

Responses

pgsql-jdbc by date

Next:From: Guillaume CottenceauDate: 2009-04-07 15:37:30
Subject: Re: JAVA-POSTGRESQL connection broken
Previous:From: Thomas KellererDate: 2009-04-07 14:39:06
Subject: Re: BLOB help - yes I've read around!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group