Re: Question on libpq parameters - Mailing list pgsql-general

From Tom Lane
Subject Re: Question on libpq parameters
Date
Msg-id 17101.1228069560@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question on libpq parameters  (Owen Hartnett <owen@clipboardinc.com>)
Responses Re: Question on libpq parameters
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query too slow with "not in" condition
Next
From: "Andrus"
Date:
Subject: Re: db backup script in gentoo