Hello 2011/8/19 EazonGuo <eazon...@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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
