Hi,
I'm trying to solve what I think must be a real trivial question.
When I use psql after every DELETE FROM table WHERE id=xxxx I get how many rows were affected, in this case, deleted.
Also I've implemented the full FrontEnd/BackEnd Protocol v3 and there after a CommandComplete also I receive how many
rowswere affected.
But now, I'm using REALstudio www.realsoftware.com with their plugin, and I can't get the rows affected.
I can send a simple DELETE FROM table WHERE id=xxxx and all what I get is nothing, no rows, no set, no info, even if
theaction didn't delete any row because the id was wrong.
They say that if the DELETE gives an empty string, means that PostgreSQL isn't returning nothing and that I have to get
thosevalues with some special values, like return parameters.
In pg/plsql I've used sometimes the GET DIAGNOSTICS <variable> = ROW_COUNT or FOUND with great success, but I really
can'tmake them work outside their main function.
There is something like select lastval(); but for rows affected ?
thanks in advance,
regards,
r.