0

Input:

select 'a string', unnest(int4range(98,104));

Current Output:

"ERROR: function unnest(int4range) does not exist"

Desired Output:

'a string', 98

'a string', 99

'a string', 100

'a string', 101

'a string', 102

'a string', 103

1 Answers1

3

generate_series:

select 'a string', generate_series(lower(r), upper(r))
from (values (int4range(98,104))) r(r);
 ?column? | generate_series 
----------+-----------------
 a string |              98
 a string |              99
 a string |             100
 a string |             101
 a string |             102
 a string |             103
 a string |             104
Clodoaldo Neto
  • 118,695
  • 26
  • 233
  • 260