PostgreSQL - 在返回结果集的存储过程中编写动态sql

PostgreSQL - 在返回结果集的存储过程中编写动态SQL

sql
CREATE OR REPLACE FUNCTION get_customers_by_country(country_name text)
RETURNS TABLE (customer_id int, customer_name text, country text) AS $$
DECLARE
    query text;
BEGIN
    -- 构建动态SQL语句
    query := 'SELECT id, name, country FROM customers WHERE country = ''' || country_name || '''';
    -- 执行动态SQL并返回结果集
    RETURN QUERY EXECUTE query;
END;
$$ LANGUAGE plpgsql;