choplin · September 5, 2012 11:20
diff --git a/eval.sql b/eval.sql
 DROP FUNCTION eval(text);

 CREATE FUNCTION eval(sql Text) RETURNS SETOF Record AS $$
    BEGIN
        RETURN QUERY EXECUTE sql;
        RETURN;
    END;
 $$ LANGUAGE plpgsql;

 SELECT * FROM eval('SELECT * FROM( VALUES (1,''a''), (3,''b'') ) AS t') AS (i Int, c Text);
 DROP FUNCTION
 CREATE FUNCTION
 i | c 
 ---+---
 1 | a
 3 | b
 (2 rows)
	DROP FUNCTION eval(text);

	CREATE FUNCTION eval(sql Text) RETURNS SETOF Record AS $$
	BEGIN
	RETURN QUERY EXECUTE sql;
	RETURN;
	END;
	$$ LANGUAGE plpgsql;

	SELECT * FROM eval('SELECT * FROM( VALUES (1,''a''), (3,''b'') ) AS t') AS (i Int, c Text);
	DROP FUNCTION
	CREATE FUNCTION
	i \| c
	---+---
	1 \| a
	3 \| b
	(2 rows)
No results found