On Wed, Mar 4, 2020 at 3:55 PM David G. Johnston <david.g.johns...@gmail.com> wrote:
> 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. > > Or, more readable depending upon your trust level: INSERT INTO dynamic_codes VALUES (1, 'DROP FUNCTION ...'); CREATE FUNCTION execute_dynamic(code_id int) AS $$ sql_cmd := (SELECT val FROM dynamic_codes WHERE id = code_id); EXECUTE sql_cmd; $$; SELECT execute_dynamic(1); David J.
