Need Help for a query - Mailing list pgsql-general

From aravind chandu
Subject Need Help for a query
Date
Msg-id 745755.14851.qm@web31404.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Need Help for a query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

            I am using this pqxx library for postgresql to run programs.The following is the query which i gave to store the data,here data.speed,data.heading are float values and data.ttime is timestamp .If i try to run this statement I end up with an error below this query.Please help me to solve this problem.

 result R1(T1.exec("insert into saveodtdata values( "+data.speed+" ,  "+data.heading+" , '" +data.ttime+" ' )" ));

 invalid operands of types `const char[33]' and `float' to binary `operator+'make: *** [main2.o] Error 1

Thank You,
Avinash.


pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Wildly erratic query performance
Next
From: Chris Browne
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?