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

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 (view raw or flat)
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

pgsql-sql by date

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

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