Re: Returning more than one value from a stored procedure

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Returning more than one value from a stored procedure
Date: 2010-07-08 10:49:44
Message-ID: m38w5ms0xj.fsf@passepartout.tim-landscheidt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Atif Jung <atifjung(at)gmail(dot)com> wrote:

> Thanks Andreas but is there no alternative?

> I'm porting from an INFORMIX database which allows the return of more than
> one value from a stored procedure without having to use in/out
> parameters. The procedure is called from several places across the system
> and will be time consuming to change all instances to include the new out
> parameters. To be able to return more than one parameter will be of great
> help to me, if it's possible.
> [...]

Andreas' example returns more than one value. Perhaps you
could clarify where your problem lies.

Tim

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Siddharth Saha 2010-07-08 10:52:02 how to change line terminator
Previous Message Atif Jung 2010-07-08 10:20:57 Re: Returning more than one value from a stored procedure