Postgres Pro
Downloads
Home   >   mailing lists

Thread: allow select from void function in void sql function

allow select from void function in void sql function

From
"Pavel Stehule"
Date:
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/
Attachment

Re: allow select from void function in void sql function

From
"Jaime Casanova"
Date:
On 3/16/06, Pavel Stehule <pavel.stehule@hotmail.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

Re: allow select from void function in void sql function

From
David Fetter
Date:
On Thu, Mar 16, 2006 at 10:56:43PM -0500, Jaime Casanova wrote:
> On 3/16/06, Pavel Stehule <pavel.stehule@hotmail.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@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

Re: allow select from void function in void sql function

From
"Pavel Stehule"
Date:
> > 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/