Message-ID: <54258.192.87.1.229.1169023509.squirrel@control.prolocation.net>
In-Reply-To: <5050.125.24.240.25.1169016593.squirrel@webmail.xs4all.nl>
References: <200701170346.l0H3kBd23330@momjian.us>
	<5050.125.24.240.25.1169016593.squirrel@webmail.xs4all.nl>
Date: Wed, 17 Jan 2007 09:45:09 +0100 (CET)
Subject: Re: Array handling in libpq
From: "Joris van Zwieten" <vanzwieten@stcorp.nl>
To: "Jeroen T. Vermeulen" <jtv@xs4all.nl>
Cc: "Bruce Momjian" <bruce@momjian.us>, vanzwieten@stcorp.nl,
	pgsql-interfaces@postgresql.org
Reply-To: vanzwieten@stcorp.nl
User-Agent: SquirrelMail/1.5.2 [CVS]
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi Bruce, Jeroen,

Thanks for your replies. This is good to know, although one worry remains
and that is loss of precision in the conversion of double to string. But
this could probably always be solved by using enough digits in the
conversion, right?

I did do some tests to see what an array received in binary format looks
like, and the format is quite easy. But I'd rather not depend on it too
much, as it's Postgres internal and could probably change in future
versions.

Jeroen: Yes, I would certainly be willing to test new code. I think it
would be nice if one could interact with libpqxx in terms of some array
type (vector?, C-style pointer?, ..?) and it would perform the conversion
to/from strings automatically.

On Wed, January 17, 2007 7:49 am, Jeroen T. Vermeulen wrote:
> On Wed, January 17, 2007 10:46, Bruce Momjian wrote:
>
>>
>> Condsidering all the processing required by the query, the conversion
>> and number of bytes sent over the nework really don't affect performance.
>>
>
> Bruce, I'm glad to hear this from someone more experienced.  A lot of
> people request support for transmitting binary data in libpqxx, which would
> take a lot of work, but there's very little hard evidence that it would
> make things noticeably better.
>
> Joris: yes, I'm afraid there's no array support in libpqxx yet so you'll
> have to do the conversion yourself.  I may have some time to work on this
> in the coming days.  Would you be willing to test-drive new code?
>
>
> Jeroen
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>
> http://www.postgresql.org/about/donate
>
>