getting the number of affected rows

Hans Bulfone <[email protected]> Wed, 18 Oct 2006 15:41:43 +0200
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
hi,

i need a way to get the number of affected rows of an
sql update or delete expression, but it seems this is
not supported by the current clsql version.

this could be easily implemented, at least for postgresql and mysql,
by changing database-execute-command to return the number
of affected rows (got via PQcmdTuples or mysql_affected_rows)
and execute-command to return the result of database-execute-command.

what do you think of this?

i can write a patch with the proposed changes for postgresql and mysql,
(and perhaps sqlite2/3).

bye,
hans.