On Thu, Mar 16, 2006 at 10:56:43PM -0500, Jaime Casanova wrote:
> On 3/16/06, Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com> wrote:
> > Hello
> > this small patch allow use sql for creating wrappers others void
> > functions. Currently void SQL function have to be empty.
> > create or replace function foo(int) returns void as ' ',''
> > language c ..; create or replace function foo() returns void as $$
> > select foo(10); $$language sql;
> i'm not clear on what the use case of this can be... of course, my
> opinion is not very important :)
I can think of a case. Let's imagine you want to do (roughly) the
equivalent of CALL, which we don't have yet. This would let you have
what amounts to a stored procedure, i.e. something that takes an
action but doesn't return rows. :)
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Remember to vote!
In response to
pgsql-patches by date
|Next:||From: Pavel Stehule||Date: 2006-03-17 05:37:44|
|Subject: Re: allow select from void function in void sql function|
|Previous:||From: Qingqing Zhou||Date: 2006-03-17 05:29:05|
|Subject: Re: Automatically setting work_mem|