Skip site navigation (1) Skip section navigation (2)

Re: SQL Functions

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: gurkan(at)resolution(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL Functions
Date: 2005-10-26 22:42:13
Message-ID: B2A0DB75-CC17-430F-8737-871FDCA2AE7F@sitening.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Oct 21, 2005, at 9:19 AM, gurkan(at)resolution(dot)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)

In response to

pgsql-sql by date

Next:From: Bath, DavidDate: 2005-10-27 00:42:10
Subject: Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum
Previous:From: Tom LaneDate: 2005-10-26 20:51:53
Subject: Re: SUM not matching up on a JOIN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group