increment lines based on a postgresql record

Question

I have a query that returns the amount and initial value and I want to transform this query into several lines according to the quantity.

Example:

Consultation:

select 3 as numero, 10001 as valorinicial

Expected exit:

 id | valor
 ----------

  1. 10001
  2. 10002
  3. 10003

Any suggestions with postgresql or postgresql/php?

Answer 1

With the native function generate_series(start, stop, step)

For your case

Select generate_series(10001 , 10003,1);

See on working on Sqlfiddle