Re: Stored Procedure Error - Mailing list pgsql-admin

From Joe Conway
Subject Re: Stored Procedure Error
Date
Msg-id 3E9B76CB.4080909@joeconway.com
Whole thread Raw
In response to Stored Procedure Error  ("Derek Hamilton" <derek@capweb.com>)
List pgsql-admin
Derek Hamilton wrote:
> I'm getting an error attempting to run the code below.  The funny thing is,
> this code worked a few hours ago.
>
> The error is:
> WARNING: line 53 at return next
> ERROR: Set-valued function called in context that cannot accept a set
>

You haven't shown us the statement causing the error, but I'd bet you
need to do:
   select * from testFunction(1);
instead of:
   select testFunction(1);

HTH,

Joe


pgsql-admin by date:

Previous
From: "Derek Hamilton"
Date:
Subject: Stored Procedure Error
Next
From: Joe Conway
Date:
Subject: Re: Stored Procedure Error