Re: Question on libpq parameters

On Mon, Dec 1, 2008 at 12:10 AM, Owen Hartnett <owen(at)clipboardinc(dot)com> wrote:
> At 1:26 PM -0500 11/30/08, Tom Lane wrote:
>>
>> Owen Hartnett <owen(at)clipboardinc(dot)com> writes:
>>>
>>> Yes, it did. I'm confused. My first parameter is a string, but the
>>> following two are integers. I thought the paramType parameter
>>> indicated the type. Do the integers need to be sprintf'd to strings?
>>
>> Yes.
>>
>> Alternatively, you could pass the integers as binary, but that's not
>> notation-free either (you need htonl or some such).
>>
>> regards, tom lane
>
> Thanks, that did it. I got confused with the binary parameters, and
> PQgetvalue returning the binary through a char * when it returns a binary
> value.

you may want to check out libpqtypes:
http://libpqtypes.esilo.com/
http://pgfoundry.org/projects/libpqtypes/

merlin