DO $$
DECLARE
row_num INTEGER;
BEGIN
FOR row_num IN 1..9 LOOP
-- 每一行的字符串
RAISE NOTICE '%', (
SELECT string_agg(FORMAT('%2$s x %1$s = %3$s ', row_num, col_num, row_num * col_num), ' ')
FROM generate_series(1, row_num) AS col_num
);
END LOOP;
END $$;
在POSTGRESQL数据库中打印出九九乘法表
于 2023-06-04 16:21:07 首次发布