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

From Chris Bowlby
Subject Re: Problem with plpgsql function
Date
Msg-id 1074193560.33449.13.camel@morpheus.hub.org
Whole thread Raw
In response to Re: Problem with plpgsql function  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
Ack, I knew it was something small, I was under the impression that I
had been using that, it just took someone to point it out to make me
look again :>... thanks..

On Thu, 2004-01-15 at 14:47, Joe Conway wrote:
> 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
-- 
Chris Bowlby <excalibur@hub.org>
Hub.Org Networking Services



pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Problem with plpgsql function
Next
From: "Denis"
Date:
Subject: Initially Deffered - FK