Please help on MS SQL Procedure (@@rowcount) translate to Postgresql Function - Mailing list pgsql-general

From annachau
Subject Please help on MS SQL Procedure (@@rowcount) translate to Postgresql Function
Date
Msg-id 1038814191.7439.annachau@hongkong.com
Whole thread Raw
Responses Re: Please help on MS SQL Procedure (@@rowcount) translate
List pgsql-general
I have some MS SQL Store Procedure code as following:

 update ot_ValReq
  set delete_ind = 'Y'
  where val_req_no in (@p_keys)

 if @@rowcount = 0
 begin
  select @i_return = 3
  goto error_handler
 end


1. How can I get @@rowcount in postgresql or have any other method to check?
2. Can goto statement use in postgresql?

Thanks a lot.

pgsql-general by date:

Previous
From: Çagil Seker
Date:
Subject: Re: ALTER TABLE & COLUMN
Next
From: Jochem van Dieten
Date:
Subject: Re: Renaming schema's [SOLVED]