Skip site navigation (1) Skip section navigation (2)

Re: Problem with plpgsql function

From: Chris Bowlby <excalibur(at)hub(dot)org>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: chris(at)hub(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem with plpgsql function
Date: 2004-01-15 19:06:01
Message-ID: 1074193560.33449.13.camel@morpheus.hub.org (view raw or flat)
Thread:
Lists: 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(at)hub(dot)org>
Hub.Org Networking Services


In response to

pgsql-sql by date

Next:From: Jack KerkhofDate: 2004-01-15 21:15:01
Subject: Trigger to identify which column(s) updated
Previous:From: Joe ConwayDate: 2004-01-15 18:47:53
Subject: Re: Problem with plpgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group