pass date type data to PQexecparams

From: pr0v4 <josip(dot)povreslo(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pass date type data to PQexecparams
Date: 2006-09-22 08:26:12
Message-ID: 277bae360609220126w55299ebpa62e92609fd823d6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I need to pass date type data from one table to another using the libpq
library wich meens that I'm using the C programming language...
PQexecparams look's like:

res = PQexecParams(conn,
"INSERT INTO orders
(userid,productid,qty,nomprice,discount,totprice,delivered,orderdate) VALUES
($1::int4,$2::int4,$3::int4,$4::int4,$5::int4,$6::int4,$7::int4,$8::QUESTION)",
8,
NULL,
paramValues,
paramLengths,
paramFormats,
1)

You can see that last 8th argument is of type QUESTION, well this is my
question wich datatype must be declared to pass date into ?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message roy simkes 2006-09-22 08:30:57 preventing pgsql to autostart
Previous Message Shane Ambler 2006-09-22 05:12:39 Re: Server->Client notification (without polling)?