Return value from anonymous function postgresql

Question

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.

Answer 1

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

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