This is a discussion on Re: Calling void functions within the pgsql Hackers forums, part of the PostgreSQL category; --> >I'm informed that the last statement of a function that returns void cannot >be a SELECT. How else is ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| >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...3/msg00196.php Regards Pavel Stehule __________________________________________________ _______________ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
| |||
| Pavel Stehule wrote: > it's problem. You cannot do it now. One year ago I sent patch > > http://archives.postgresql.org/pgsql...3/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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
| ||||
| >Pavel Stehule wrote: > > it's problem. You cannot do it now. One year ago I sent patch > > > > http://archives.postgresql.org/pgsql...3/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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |