Re: allow select from void function in void sql function

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. :)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!