将ORDER BY作为参数传递给postgres函数的最佳方法

CREATE OR REPLACE FUNCTION get_sorted_data(order_by_column text)
RETURNS TABLE(column_name text) AS $$
BEGIN
    RETURN QUERY EXECUTE
    format('SELECT column_name FROM your_table ORDER BY %I', order_by_column);
END;
$$ LANGUAGE plpgsql;

SELECT * FROM get_sorted_data('your_column_to_sort_by');

CREATE VIEW unordered_data AS
SELECT column_name FROM your_table;

CREATE OR REPLACE FUNCTION get_data()
RETURNS TABLE(column_name text) AS $$
BEGIN
    RETURN QUERY SELECT column_name FROM unordered_data;
END;
$$ LANGUAGE plpgsql;

SELECT * FROM get_data() ORDER BY your_column_to_sort_by;

PREPARE get_sorted_data (text) AS
SELECT column_name FROM your_table ORDER BY $1;

EXECUTE get_sorted_data('your_column_to_sort_by');