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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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