Getting number of affected rows after DELETE FROM
От | Raimon Fernandez |
---|---|
Тема | Getting number of affected rows after DELETE FROM |
Дата | |
Msg-id | 0654C853-A700-457E-88E4-F80FBE1E0295@montx.com обсуждение исходный текст |
Ответ на | Re: Getting number of affected row after performing update (Richard Huxton <dev@archonet.com>) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: