Re: Stored Procedure Error

From: Joe Conway <mail(at)joeconway(dot)com>
To: Derek Hamilton <derek(at)capweb(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Stored Procedure Error
Date: 2003-04-15 03:04:43
Message-ID: 3E9B76CB.4080909@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Conway 2003-04-15 03:23:22 Re: Stored Procedure Error
Previous Message Derek Hamilton 2003-04-15 01:56:26 Stored Procedure Error