Postgres Pro
Downloads
Home   >   mailing lists

Re: set-valued function called in context that cannot accept a set - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: set-valued function called in context that cannot accept a set
Date
Msg-id 20090306204923.GA30163@depesz.com
Whole thread Raw
In response to Re: set-valued function called in context that cannot accept a set  ("Eric B. Ridge" <ebr@tcdi.com>)
Responses Re: set-valued function called in context that cannot accept a set  ("Eric B. Ridge" <ebr@tcdi.com>)
List pgsql-general
Tree view 
On Fri, Mar 06, 2009 at 03:33:30PM -0500, Eric B. Ridge wrote:
> So my question is really, what's the difference and why doesn't this
> work with PL/PGSQL functions?

because it is long-time limitation of setof-returning plplsql functions
(i think all pl/*).
it is removed in 8.4
http://www.depesz.com/index.php/2008/11/03/waiting-for-84-pl-srf-functions-in-selects/

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: "Eric B. Ridge"
Date:
Subject: Re: set-valued function called in context that cannot accept a set
Next
From: "Eric B. Ridge"
Date:
Subject: Re: set-valued function called in context that cannot accept a set