annachau wrote:
> I have some MS SQL Store Procedure code as following:
>
[...snip...]
>
> 1. How can I get @@rowcount in postgresql or have any other method to check?
> 2. Can goto statement use in postgresql?
See:
http://developer.postgresql.org/docs/postgres/plpgsql.html
and in particular, look at the bottom of this page for the answer to #1:
http://developer.postgresql.org/docs/postgres/plpgsql-statements.html
and for alternatives for #2 see:
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html
and
http://developer.postgresql.org/docs/postgres/plpgsql-errors-and-messages.html
HTH,
Joe