Thread: Please Help on MS SQL7.0 Procedure to PostgreSQL

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.

annachau wrote:
> 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?

Use PostgreSQL 7.3 release candidate 2. See:

http://developer.postgresql.org/docs/postgres/xfunc-tablefunctions.html

for details regarding returning sets of rows. Download 7.3RC2 here:

http://www.ca.postgresql.org/ftpsite/beta


Mike Mascari
mascarm@mascari.com