How to assign result of a sql query to a variable and use it into a built in function?

Question

Looking for a solution In Postgresql

declare n_rows integer := select count(*) from sample;

SELECT generate_series AS serial_num
FROM generate_series(0, n_rows + 1)

user330315 · Accepted Answer · 2020-12-16 14:00:38Z

1

SQL has no variables, so short of using a function, you can use a common table expression:

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)

Or just:

SELECT *
FROM generate_series(0, (select count(*) + 1 from sample)) as g(serial_num)

answered Dec 16, 2020 at 14:00

user330315

Sign up to request clarification or add additional context in comments.

1 Answer 1