SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create function dynnamic_action(action char) returns table(res integer) AS $$ declare sql text; begin sql = 'SELECT 1 ' || action || ' 2'; RETURN QUERY EXECUTE sql; end; $$ LANGUAGE plpgsql; select dynnamic_action('+'); select dynnamic_action('*');

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear