pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Czuczy Gergely <phoemix@harmless.hu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: PQexecParams and types
Date: Tue, 3 Feb 2004 15:56:06 +0100 (CET)
Message-ID: <Pine.LNX.4.44.0402031555080.30492-100000@localhost> (raw)
In-Reply-To: <17666.1075819993@sss.pgh.pa.us>

hello

to leave it unspecified what value should I set to the paramTypes array?
and could you insert this answer to to docs, it could be useful


Bye,

Gergely Czuczy
mailto: phoemix@harmless.hu
PGP: http://phoemix.harmless.hu/phoemix.pgp

The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.

On Tue, 3 Feb 2004, Tom Lane wrote:

> Czuczy Gergely <phoemix@harmless.hu> writes:
> > i've read in the docs to use the proper indexes both types must match in
> > the where clause, to achive this the user can simply put a string into the
> > side of the equation mark and pgsql will convert it automaticly. my
> > question is, when I'm using PQexecParams, should I give all the values as
> > a string, and it will be converted, or I have to figure out the type of
> > the given field somehow?
>
> You should leave the parameter types unspecified.  Their types will be
> resolved in much the same way that a quoted literal is handled.
>
> 			regards, tom lane
>




view thread (4+ messages)  latest in thread

Message-ID: <Pine.LNX.4.44.0402031555080.30492-100000@localhost>
Permalink:  ../Pine.LNX.4.44.0402031555080.30492-100000@localhost/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0402031555080.30492-100000@localhost

 · 

reply

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-performance@postgresql.org
  Cc: phoemix@harmless.hu, tgl@sss.pgh.pa.us
  Subject: Re: PQexecParams and types
  In-Reply-To: <Pine.LNX.4.44.0402031555080.30492-100000@localhost>

* 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