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.