Re: C++ code - PGRES_TUPLES_OK is not returned when DELETE performed

Hey Yan Cheng,

The status of command is PGRES_COMMAND_OK only when performed
command was not returns data, e.g. DELETE (without RETURNING clause),
BEGIN, COMMIT etc.
The status PGRES_TUPLES_OK only when performed command was
SELECT, SHOW or UPDATE / DELETE with RETURNING clause and etc.

2010/12/15 Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>

> I realize for the following code :
>
> PGconn *connection = this->connection.getConnection();
> PGresult *res = PQexec(connection, "DELETE FROM measurement_statistic WHERE
> fk_lot_id = 47");
>
> // status always false??
> const bool status = (PQresultStatus(res) == PGRES_TUPLES_OK);
>
> status will always remain false, although the actual row in database had
> been delete.
>
> I execute the above statement (DELETE FROM measurement_statistic WHERE
> fk_lot_id = 47) through pgadmin. It works fine.
>
> May I know why PGRES_TUPLES_OK is not being returned when I use DELETE?
> When I try to execute SELECT statement, PGRES_TUPLES_OK can be returned.
>
> Thanks and Regards
> Yan Cheng CHEOK
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.