check the execution status of stored procedure
Currently, I try to call a stored procedure with void returned type.
PGresult *res = PQexec(this->getConnection(), "SELECT * FROM create_tables()");
if (PQresultStatus(res) != PGRES_COMMAND_OK)
{
PQclear(res);
return false;
}
Since the returned type of stored procedure is void, I will always fall in to the block
if (PQresultStatus(res) != PGRES_COMMAND_OK) {}
Is there any better way, I can check whether the stored procedure had been executed without problem?
Thanks and Regards
Yan Cheng CHEOK
Yan Cheng Cheok <yccheok@yahoo.com> writes:
Currently, I try to call a stored procedure with void returned type.
PGresult *res = PQexec(this->getConnection(), "SELECT * FROM create_tables()");
if (PQresultStatus(res) != PGRES_COMMAND_OK)
{
PQclear(res);
return false;
}
Since the returned type of stored procedure is void, I will always fall in to the block
if (PQresultStatus(res) != PGRES_COMMAND_OK) {}
A successful SELECT command will return PGRES_TUPLES_OK, not
PGRES_COMMAND_OK. Whether the function result is void or not doesn't
change that.
regards, tom lane