Re: Problem with plpgsql function

From: Joe Conway <mail(at)joeconway(dot)com>
To: chris(at)hub(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem with plpgsql function
Date: 2004-01-15 18:47:53
Message-ID: 4006E059.7030802@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Bowlby 2004-01-15 19:06:01 Re: Problem with plpgsql function
Previous Message Chris Bowlby 2004-01-15 18:39:27 Problem with plpgsql function