我可以在sql函数中使用什么代替#Temp表

CREATE FUNCTION myFunction()
RETURNS TABLE (id INT, name VARCHAR(50))
AS $$
BEGIN
    RETURN QUERY
    SELECT * FROM #Temp;
END;
$$ LANGUAGE plpgsql;

CREATE FUNCTION myFunction()
RETURNS TABLE (id INT, name VARCHAR(50))
AS $$
BEGIN
    RETURN QUERY
    WITH Temp AS (
        SELECT * FROM myTable
    )
    SELECT * FROM Temp;
END;
$$ LANGUAGE plpgsql;