On Wed, Mar 4, 2020 at 3:48 PM Rory Campbell-Lange <r...@campbell-lange.net>
wrote:

> Any thoughts on how to wrap pl/pgsql function dropping and recreation code
> within a wrapper pl/pgsql function?


Not endorsing this but dynamic SQL works just fine (though can get hard to
read).  Use format() and EXECUTE ... USING liberally.

CREATE FUNCTION perform_update()...
AS $outer$
BEGIN

drop_sql := $inner$ DROP FUNCTION ...; $inner$
EXECUTE drop_sql;

END;
$outer$;

David J.

Reply via email to