[HACKERS] number of affected tuples

hi im having a problem while using the PQcmdTuples(). Consider the following code snippet: there exists a table table1 (name character(30), age integer) <...snip...> PGresult *res = PQexec("prepare p_stmt (integer) update table1 set age = age + 1 where age = $1"); PQclear (res); res = PQexec ( ex

[HACKERS] Speeding up operations

hi... im on a project using Postgres. The project involves, at times, upto 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts into a 2 column table (one col=integer, 2nd col=character). I used the Prepare... and execute method, so i basically had 5M execute statements and

[HACKERS] no of affected rows in prepared stmts

hi whenever i call an execute on a prepared statement, i get the return value of PQcmdTuples() as NULL even if the query did modify tuples... how can i get the number of affected tuples? thanx in adv. rahul ---(end of broadcast)--- TIP 1: subscribe

[HACKERS] Batch Operations

hi, im currently working on a project that requires batch operations - eg. Batch insert/update etc. The database im using is PostgreSQL. However, i cannot find any documentation for batch opeartions on PostgreSQL. Does anyone know how to do this, or if it is possible? Thanx in advance regards rahu