Re: Howto return values from a function

From: "Ian Barwick" <barwick(at)gmail(dot)com>
To: "A B" <gentosaker(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Howto return values from a function
Date: 2008-05-16 08:13:46
Message-ID: 1d581afe0805160113w8df3168qaec01363a4a31fa2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/5/16 A B <gentosaker(at)gmail(dot)com>:
>> How you generate the results is up to you. when you have them you
>> either use RETURN NEXT or RETURN QUERY to return them to the caller.
>
> Now I get the reply
>
> ERROR: set-valued function called in context that cannot accept a set
> CONTEXT: PL/pgSQL function "actionlist" line 11 at return next

You probably need to do

SELECT * FROM actionlist(123)

Ian Barwick

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-05-16 08:17:59 Re: Howto return values from a function
Previous Message samslists@gmail.com 2008-05-16 07:34:36 Setting up phppgadmin under https/ssl (Apache)