Yan Cheng Cheok <yccheok@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
