Escaping to return `TEXT[]` type with a `RETURN QUERY EXECUTE` and `VALUES` statement in PostgreSQL
I'm trying to return TEXT[] type from my_func() with a RETURN QUERY EXECUTE and VALUES statement. But calling my_func() which has " in '' got the error as shown below: CREATE FUNCTION my_func() RETURNS SETOF TEXT[] AS $$ BEGIN --…