Re: [SQL] CREATE VIEW (dynamically)

> CREATE FUNCTION "requests_insert_after" () RETURNS opaque AS ' > DECLARE > view_name text; > BEGIN > view_name := ''request_'' || NEW.id; > CREATE VIEW view_name AS select * from groups; > return NEW; > END' LANGUAGE 'plpgsql'; > > CREATE TRIGGER "requests_insert_aft

[SQL] CREATE VIEW (dynamically)

code << CREATE FUNCTION "requests_insert_after" () RETURNS opaque AS ' DECLARE view_name text; BEGIN view_name := ''request_'' || NEW.id; CREATE VIEW view_name AS select * from groups; return NEW; END' LANGUAGE 'plpgsql'; CREATE TRIGGER "requests_insert_after"