Re: Calling void functions

Started by Pavel Stehulealmost 19 years ago3 messages
#1Pavel Stehule
pavel.stehule@hotmail.com

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/

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Pavel Stehule (#1)

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/

#3Pavel Stehule
pavel.stehule@hotmail.com
In reply to: Peter Eisentraut (#2)

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/