how to get the effected row after execute a query
Hello, I have a question. In SQL Server, we can use @@rowcount to get the
efftected row which record last query 's effected row .So I have a
question:
In Postgresql, how we can get the effected row? Is there some similar
functions to complete this?
--
Best regards
Eazon
Import Notes
Reply to msg id not found: CACZa+5uGQQv-Ky+NCHKzq0quBzpTe1kOaww7q4DHzVuFvNDUeA@mail.gmail.comReference msg id not found: CACZa+5uGQQv-Ky+NCHKzq0quBzpTe1kOaww7q4DHzVuFvNDUeA@mail.gmail.com
Hello
2011/8/19 EazonGuo <eazonguo@gmail.com>:
Hello, I have a question. In SQL Server, we can use @@rowcount to get the
efftected row which record last query 's effected row .So I have a
question:
In Postgresql, how we can get the effected row? Is there some similar
functions to complete this?
It depends on API hat you use. You can use GET DIAGNOSTICS statement
in PL/pgSQL. On client side, you should to use a PQcmdtuples function
or their equivalent (depends on interface).
http://www.postgresql.org/docs/8.4/static/libpq-exec.html#LIBPQ-EXEC-SELECT-INFO
Regards
Pavel Stehule
Show quoted text
--
Best regards
Eazon