Please Help on MS SQL7.0 Procedure to PostgreSQL

From: "annachau" <annachau(at)hongkong(dot)com>
To: "" <pgsql-general(at)postgresql(dot)org>
Subject: Please Help on MS SQL7.0 Procedure to PostgreSQL
Date: 2002-11-21 15:38:59
Message-ID: 1037893139.6926.annachau@hongkong.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message QUINN, JAY (SBCSI) 2002-11-21 15:47:31 Re: Dumb Newbie Question - Mandrake 9.0 / PGSQL 7.2
Previous Message Doug McNaught 2002-11-21 15:04:34 Re: tcpip connections..