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
>
> --
> Best regards
> Eazon
>