From: Joris van Zwieten <vanzwieten@stcorp.nl>
To: Jeroen T. Vermeulen <jtv@xs4all.nl>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: vanzwieten@stcorp.nl
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Array handling in libpq
Date: Wed, 17 Jan 2007 09:45:09 +0100 (CET)
Message-ID: <54258.192.87.1.229.1169023509.squirrel@control.prolocation.net> (raw)
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>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: vanzwieten@stcorp.nl, jtv@xs4all.nl, bruce@momjian.us
Subject: Re: Array handling in libpq
In-Reply-To: <54258.192.87.1.229.1169023509.squirrel@control.prolocation.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox