Db Name | insert | select | update | delete |
  PostgreSql |   8034 |   9808 |   6857 |   9314 |
       MySql |  22675 |  16035 |  18782 |  19992 |
    TimesTen |  85792 | 198601 |  70466 |  66461 |

CREATE TABLE bench (
    id integer NOT NULL, 
    value integer NOT NULL, 
    CONSTRAINT bench_pk PRIMARY KEY (id) 
);

INSERT INTO bench (id, value) VALUES ($1, $2)
SELECT value FROM bench WHERE id=$1
UPDATE bench SET value=$1 WHERE id=$2
DELETE FROM bench WHERE id=$1

db_insert(1,1);
db_insert(1,2);
db_insert(2,3);
db_select(2,&value);

Retcode [-1] when executing SQLExecute(stmt_insert)
Error [-1] in SQLExecute(stmt_insert)ERROR:
[unixODBC]ERROR: duplicate key value violates unique constraint "bench_pk"
Key (id)=(1) already exists.;
Error while executing the query
ODBC Error/Warning = 23505, Additional Error/Warning = 7

Retcode [-1] when executing SQLExecute(stmt_insert)
Error [-1] in SQLExecute(stmt_insert)ERROR:
[unixODBC]Error while executing the query
ODBC Error/Warning = S1000, Additional Error/Warning = 7

             Db Name |select1 | insert | select | update | delete |
  PostgreSql (libpq) |  22990 |  15975 |  16416 |  10610 |  15529 | unix_socket
  PostgreSql (libpq) |  14877 |  11791 |  12405 |   9006 |  11950 | tcp/ip
   PostgreSql (ODBC) |  11888 |   9635 |   9026 |   7773 |   9625 | tcp/ip
        MySql (ODBC) |  24884 |  22349 |  15943 |  18581 |  19848 | unix_socket, Memory
        MySql (ODBC) |  24806 |  14148 |  13864 |  11473 |  12225 | unix_socket, InnoDB 
        MySql (ODBC) |  13934 |  16372 |  12617 |  14208 |  15150 | tcp/ip, Memory
        MySql (ODBC) |  13103 |  11727 |  11289 |   9972 |  10438 | tcp/ip, InnoDB
     TimesTen (ODBC) | 143061 |  82169 | 207125 |  73152 |  62719 | shm
     TimesTen (ODBC) |   7796 |  14282 |   7787 |  13910 |  12945 | tcp/ip

void db_prepare() {
....
    res = PQprepare(conn, STMT_ID_SELECT1, Q_SELECT1, 0, NULL);
    CHECK_RESULT(res);
    PQclear(res);
....
}

void db_select1(int32_t* value) {
    if (debug) {
        fprintf(stderr, "db_select1()\n");
    }
    PGresult* res = PQexecPrepared(conn,
            STMT_ID_SELECT1,
            0,
            NULL,
            NULL,
            NULL,
            1);
    CHECK_RESULT(res);
    *value = -1;
    if (PQntuples(res) == 0) {
        fprintf(stderr, "db_select1() return no rows\n");
        if (exit_on_error) {
            exit(EXIT_FAILURE);
        }
    } else {
        *value = ntohl(*(int32_t *) PQgetvalue(res, 0, 0));
        if (debug) {
            fprintf(stderr, "db_select1() return %d\n", *value);
        }
    }
    PQclear(res);
}