I have a query that returns the quantity and initial value and I want to turn this query into multiple rows by quantity.
Example:
Inquiry:
select 3 as numero, 10001 as valorinicial
Expected output:
id | valor
----------
1. 10001
2. 10002
3. 10003
Any suggestions with postgresql or postgresql / php ?