Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group