Please help on MS SQL Procedure (@@rowcount) translate to Postgresql Function

From: "annachau" <annachau(at)hongkong(dot)com>
To: "" <pgsql-general(at)postgresql(dot)org>
Subject: Please help on MS SQL Procedure (@@rowcount) translate to Postgresql Function
Date: 2002-12-02 07:29:51
Message-ID: 1038814191.7439.annachau@hongkong.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jochem van Dieten 2002-12-02 09:50:26 Re: Renaming schema's [SOLVED]
Previous Message Neil Conway 2002-12-02 07:17:22 Re: differences between 7.2.x and 7.3.