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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Chris Bowlby wrote:
> select get_account_info('');
>  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('');



In response to


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-2017 The PostgreSQL Global Development Group