Re: set-valued function called in context that cannot accept a set

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: "Eric B(dot) Ridge" <ebr(at)tcdi(dot)com>
Cc: rod(at)iol(dot)ie, pgsql-general(at)postgresql(dot)org
Subject: Re: set-valued function called in context that cannot accept a set
Date: 2009-03-06 20:49:23
Message-ID: 20090306204923.GA30163@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric B. Ridge 2009-03-06 21:10:59 Re: set-valued function called in context that cannot accept a set
Previous Message Eric B. Ridge 2009-03-06 20:33:30 Re: set-valued function called in context that cannot accept a set