在交叉表查询postgres中传递参数

-- 创建一个参数化查询
PREPARE cross_tab_query (integer, integer) AS
SELECT *
FROM crosstab(
    'SELECT category, month, sales
    FROM sales_table
    WHERE category = $1
    AND month = $2
    ORDER BY category, month',
    'VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12)'
) AS ct (category integer, "January" numeric, "February" numeric, "March" numeric, "April" numeric, "May" numeric, "June" numeric, "July" numeric, "August" numeric, "September" numeric, "October" numeric, "November" numeric, "December" numeric);

-- 执行参数化查询
EXECUTE cross_tab_query(1, 2022);