User-Agent: Microsoft-Entourage/10.1.4.030702.0
Date: Wed, 07 Jun 2006 10:05:32 -0600
Subject: Re: libpq PQexecParams and arrays
From: Keary Suska <hierophant@pcisys.net>
To: Alexey Slynko <slynko@tronet.ru>
CC: Postgres-Interfaces <pgsql-interfaces@postgresql.org>
Message-ID: <C0AC556C.2B270%hierophant@pcisys.net>
In-Reply-To: <44869432.40200@tronet.ru>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

on 6/7/06 2:54 AM, slynko@tronet.ru purportedly said:

>>> I wish to call PQexecParams with array of uint32_t values.
>>> I've tried to use example from src/test/examples/testlibpq3.c, but with
>>> no effect - it's unusable for input array.
>>> 
>>> Have anyone an idea, how it can be done?
>> 
>> Have you tried passing all parameters, including especially the appropriate
>> paramTypes and paramFormats parameters?
> Of course
> 
>> I believe that doing this should
>> permit libpq to understand binary data.
> No, it doesn't.
> I've found, that array parsed at the server side by array_recv function.
> Is there is a way to send an array of arbitrary type by libpq?

To make sure that I understand, do you mean passing a paramValues as an
array of uint32, or passing values to a *column* that is an array column? If
it's the latter (array column), I don't think libpq supports array columns
in this way.

If it is just a matter of passing binary numeric values, I thought it was
supported by libpq, but maybe not. The documentation is ambiguous in many
places, so it is possible that libpq's binary support is only for blobs and
not for other data types.

I have never tried passing binary data, as I tend to find it easier in my
applications to pass textual representations, so I can't say for sure.

You may have to "convert" your int array into an array of char.

Best,

Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"