allow select from void function in void sql function

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;

regards
Pavel

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/

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;
>
> regards
> Pavel
>

i'm not clear on what the use case of this can be... of course, my
opinion is not very important :)

--
regards,
Jaime Casanova

"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
Randal L. Schwartz

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!

> > 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;
> >
> > regards
> > Pavel
> >
>
>i'm not clear on what the use case of this can be... of course, my
>opinion is not very important :)
>

First. I write bigger C library - implementation of some dbms_packages and
plvision packages. I don't expect using plpgsql. I have a lot of void
functions. Usually set_...unset_ with and I need sql language for createing
wrappers for default values. That's all.
Second. The logic in PostgreSQL is wrong now. Is too hard and too simple. I
can get VOID value via SELECT void function too.

Pavel

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/