Re: Question on libpq parameters

On Mon, Dec 1, 2008 at 12:10 AM, Owen Hartnett <owen@clipboardinc.com> wrote:
> At 1:26 PM -0500 11/30/08, Tom Lane wrote:
>>
>> Owen Hartnett <owen@clipboardinc.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