Re: Please help on MS SQL Procedure (@@rowcount) translate - Mailing list pgsql-general

From Joe Conway
Subject Re: Please help on MS SQL Procedure (@@rowcount) translate
Date
Msg-id 3DEC2C6D.5000805@joeconway.com
Whole thread Raw
In response to Please help on MS SQL Procedure (@@rowcount) translate to Postgresql Function  ("annachau" <annachau@hongkong.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Timothy Grant
Date:
Subject: Re: \d functionality in a query.
Next
From: Bruce Momjian
Date:
Subject: Re: Segmentation fault while COPY in 7.3