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
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 |