Re: SQL Functions - Mailing list pgsql-sql

From Thomas F. O'Connell
Subject Re: SQL Functions
Date
Msg-id B2A0DB75-CC17-430F-8737-871FDCA2AE7F@sitening.com
Whole thread Raw
In response to SQL Functions  (gurkan@resolution.com)
List pgsql-sql
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)


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: SUM not matching up on a JOIN
Next
From: "Bath, David"
Date:
Subject: Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum