X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CA666DAFA7 for ; Wed, 26 Oct 2005 19:42:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21347-09 for ; Wed, 26 Oct 2005 22:42:14 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 9CAF2DAFA1 for ; Wed, 26 Oct 2005 19:42:15 -0300 (ADT) Received: (qmail 3560 invoked from network); 26 Oct 2005 22:42:16 -0000 Received: from pcp0012204803pcs.blairblvd.tn.nash.comcast.net (HELO ?192.168.15.103?) (69.245.49.69) by 0 with SMTP; 26 Oct 2005 22:42:16 -0000 In-Reply-To: <1129904391.4358f90781664@www.resolution.com> References: <1129904391.4358f90781664@www.resolution.com> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: "Thomas F. O'Connell" Subject: Re: SQL Functions Date: Wed, 26 Oct 2005 17:42:13 -0500 To: gurkan@resolution.com X-Mailer: Apple Mail (2.734) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.016 required=5 tests=[AWL=0.016] X-Spam-Level: X-Archive-Number: 200510/348 X-Sequence-Number: 23201 On Oct 21, 2005, at 9:19 AM, gurkan@resolution.com wrote: > I have been trying to find a way to return more than one but > different types of > variables. How do I return more than one but mix types of variables. > Any help is appriaciated. > Thanks; In PostgreSQL 8.1, you'll have output parameters available. http://developer.postgresql.org/docs/postgres/plpgsql.html#PLPGSQL- OVERVIEW -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Open Source Solutions. Optimized Web Development. http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-469-5150 615-469-5151 (fax)