Re: Problem with plpgsql function - Mailing list pgsql-sql

From Joe Conway
Subject Re: Problem with plpgsql function
Date
Msg-id 4006E059.7030802@joeconway.com
Whole thread Raw
In response to Problem with plpgsql function  (Chris Bowlby <excalibur@hub.org>)
Responses Re: Problem with plpgsql function
List pgsql-sql
Chris Bowlby wrote:
> select get_account_info('test.com');
> 
>  I get this error:
> 
> ERROR:  set-valued function called in context that cannot accept a set

This is the "classic" SRF error -- you need to use an SRF like a 
relation in the FROM clause, so do this instead:
  select * FROM get_account_info('test.com');

HTH,

Joe




pgsql-sql by date:

Previous
From: Chris Bowlby
Date:
Subject: Problem with plpgsql function
Next
From: Chris Bowlby
Date:
Subject: Re: Problem with plpgsql function