Received: from Kharma.Nextshift.Net (kharma.nextshift.net [216.200.15.16])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA72995
	for <pgsql-sql@postgresql.org>; Wed, 12 Jan 2000 05:09:05 -0500 (EST)
	(envelope-from thomas.leavitt@clickrebates.com)
Received: from bruce1 (dialup-209.245.143.254.SanJose1.Level3.net
	[209.245.143.254])
	by Kharma.Nextshift.Net (8.9.3/8.9.0) with SMTP id CAA27055
	for <pgsql-sql@postgresql.org>; Wed, 12 Jan 2000 02:08:58 -0800 (PST)
From: "Thomas Leavitt" <thomas.leavitt@clickrebates.com>
To: <pgsql-sql@postgresql.org>
Subject: simple question
Date: Wed, 12 Jan 2000 02:10:36 -0800
Message-ID: <NDBBLIDGKLINCGOKPFFKMEFKCKAA.thomas.leavitt@clickrebates.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I would like to know if function parameters are used to pass output values
back to the function.

e.g.

create function func1(p1 varchar,p2 varchar OUTPUT, p3 varchar OUTPUT)
BEGIN
	SELECT p1 = t.foo1, p3 = t.foo2
	FROM test_table t
	WHERE foo3 = p1
END

DECLARE p2 varchar(50), p3 varchar(50)
CALL func1('abc',@p2 out,@p3 out)
PRINT @p2
PRINT @p3
--
Thomas Leavitt -- thomas.leavitt@clickrebates.com; 408-591-3342
Co-Founder/COO, ClickRebates.Com, Inc. (www.clickrebates.com)
Get Paid What You're Worth!

Sign up for our pre-launch guest list and refer your friends!

Or use our working prototype at www.clickrebates.org to "Surf for a Higher
Cause" (earn money for charity)