Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE FUNCTION my_func() RETURNS SETOF TEXT[] AS $f$
BEGIN               -- ↓              ↓ ↓ ↓ ↓           ↓ ↓ ↓ ↓  ↓
  RETURN QUERY EXECUTE 'VALUES (ARRAY["a","b"]), (ARRAY["c","d"])';
END;
$f$ LANGUAGE plpgsql;

SELECT * FROM my_func();

CREATE FUNCTION

ERROR:  column "a" does not exist
LINE 1: VALUES (ARRAY["a","b"]), (ARRAY["c","d"])
                      ^
QUERY:  VALUES (ARRAY["a","b"]), (ARRAY["c","d"])
CONTEXT:  PL/pgSQL function my_func() line 3 at RETURN QUERY

CREATE OR REPLACE FUNCTION my_func() RETURNS SETOF TEXT[] AS $f$
BEGIN               -- ↓                ↓ ↓ ↓ ↓
  RETURN QUERY EXECUTE $q$VALUES (ARRAY['a','b']), 
                                 (ARRAY['c','d'])
                       $q$;
END;
$f$ LANGUAGE plpgsql;

SELECT * FROM my_func();

CREATE FUNCTION

my_func

{a,b}

{c,d}

SELECT 2

CREATE OR REPLACE FUNCTION my_func() RETURNS SETOF TEXT[] AS $f$
BEGIN               -- ↓                ↓    ↓    ↓    ↓
  RETURN QUERY EXECUTE $q$VALUES (ARRAY[$v1$a$v1$,$v2$b$v2$]), 
                                 (ARRAY[$v3$c$v3$,$v4$d$v4$])
                       $q$;
END;
$f$ LANGUAGE plpgsql;

SELECT * FROM my_func();

CREATE FUNCTION

my_func

{a,b}

{c,d}

SELECT 2