From: | Mike Mascari <mascarm(at)mascari(dot)com> |
---|---|
To: | annachau <annachau(at)hongkong(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Please Help on MS SQL7.0 Procedure to PostgreSQL |
Date: | 2002-11-25 07:55:13 |
Message-ID: | 3DE1D761.6070704@mascari.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)mascari(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Hilmar Lapp | 2002-11-25 08:02:24 | transaction aborted, queries ignored |
Previous Message | Stephan Szabo | 2002-11-25 07:52:37 | Re: Calculated fileds in pg |