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.