Re: DELETE...RETURNING problem with libpq

I tried your code, but it does not work... the function returns a string : "0". When I check, this command properly modifies one row, as expected.

I don't know if it may help, but just in case... The DELETE operation is not performed on a table : it is performed on a view. I have a rule on that view that, instead of performing a delete on the corresponding table, performs an update with table entry tagged as deleted (in a dedicated column of the table). This code (sql part) works for years and, when executing this command by other ways (php and pgadmin), it deletes and returns expected data. With libpq, it deletes, but does not return anything.

Regards,

Brice