Thread: Re: Calling void functions

Re: Calling void functions

From
"Pavel Stehule"
Date:
>I'm informed that the last statement of a function that returns void cannot 
>be a SELECT.  How else is one supposed to call another function which also 
>returns void?
>
>E.g.,
>
>CREATE FUNCTION foo (a int, b int) RETURNS void
>    LANGUAGE plpgsql
>    AS $$ do important things $$;
>
>CREATE FUNCTION foo (a int) RETURNS void
>    LANGUAGE sql
>    AS $$ SELECT foo($1, default-value); $$;

Hello Peter

it's problem. You cannot do it now. One year ago I sent patch

http://archives.postgresql.org/pgsql-patches/2006-03/msg00196.php

Regards
Pavel Stehule

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



Re: Calling void functions

From
Peter Eisentraut
Date:
Pavel Stehule wrote:
> it's problem. You cannot do it now. One year ago I sent patch
>
> http://archives.postgresql.org/pgsql-patches/2006-03/msg00196.php

The only comments to that were that no one knew what it was good for.  
But now we know, so I think we should add your patch.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


Re: Calling void functions

From
"Pavel Stehule"
Date:
>Pavel Stehule wrote:
> > it's problem. You cannot do it now. One year ago I sent patch
> >
> > http://archives.postgresql.org/pgsql-patches/2006-03/msg00196.php
>
>The only comments to that were that no one knew what it was good for.
>But now we know, so I think we should add your patch.
>

Tom Lane did it before you

nice a day
Pavel

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. 
http://www.msn.cz/