在Postgresql中寻找解决方案
declare n_rows integer := select count(*) from sample;
SELECT generate_series AS serial_num
FROM generate_series(0, n_rows + 1)
SQL没有变量,因此除了使用函数外,还可以使用公用表表达式:
with var as (
select count(*) as n_rows
from sample
)
SELECT g.serial_num
FROM var, generate_series(0, n_rows + 1) as g(serial_num)
要不就:
SELECT *
FROM generate_series(0, (select count(*) + 1 from sample)) as g(serial_num)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句