Please Help on MS SQL7.0 Procedure to PostgreSQL - Mailing list pgsql-general

From annachau
Subject Please Help on MS SQL7.0 Procedure to PostgreSQL
Date
Msg-id 1038210285.29904.annachau@hongkong.com
Whole thread Raw
List pgsql-general
I have some problems on MS SQL procedure convert to PostgreSQL function. Please give me some advice.

I have many procedure in MS SQL which return more than one value.
Example:
CREATE procedure usp_BBox_chk_policy_rule
   @appln_ref_no       varchar(12),
   @version            integer,
   @offer_seq          numeric(18,0),
   @policyID           char(3),
   @pass_ind           integer  out,
   @ret_cnt_off_desc   varchar(500) out,
   @ret_cnt_off_desc_l varchar(500) out

How can I return more than one value?

Thanks a lot.

pgsql-general by date:

Previous
From: Markus Wagner
Date:
Subject: Re: stability of pg library usage
Next
From: "annachau"
Date:
Subject: Convert Dynmaic SQL from MS SQL procedure to PostgreSQL PL/pgsql function