匿名函数 postgresql 的返回值

Return value from anonymous function postgresql

提问by Arturgspb

How to?

如何？

For easy example. I have a simple function:

举个简单的例子。我有一个简单的功能：

DO LANGUAGE plpgsql $$ DECLARE
BEGIN
EXECUTE 'SELECT NOW()';
END $$;

How I can return value of "NOW()" or other values from also anonymous function? The function is given as an example I have a more complex function.

我如何从匿名函数返回“NOW()”的值或其他值？以函数为例，我有一个更复杂的函数。

回答by vyegorov

It is not an anonymous function, but rather anonymous code block.

它不是匿名函数，而是匿名代码块。

• if you need to returnvalues, consider creating real functions;
• if you need to output some debug info, just RAISE NOTICE.

• 如果您需要返回值，请考虑创建真正的函数；
• 如果您需要输出一些调试信息，只需RAISE NOTICE.

回答by Clodoaldo Neto

DO LANGUAGE plpgsql $$ DECLARE
BEGIN
execute '
create temporary table t
as
SELECT NOW()
';
END $$;

select * from t;