-- one row: 3
select * from generate_series(3,3);
 generate_series 
-----------------
               3
(1 row)

-- one row: 3
select * from generate_series(3,3,1);
 generate_series 
-----------------
               3
(1 row)

-- one row: 3
select * from generate_series(3,3,2);
 generate_series 
-----------------
               3
(1 row)

-- one row: 3
select * from generate_series(3,3,-2);
 generate_series 
-----------------
               3
(1 row)

-- three rows: 1,2,3
select * from generate_series(1,3);
 generate_series 
-----------------
               1
               2
               3
(3 rows)

-- three rows: 1,2,3
select * from generate_series(1,3,1);
 generate_series 
-----------------
               1
               2
               3
(3 rows)

-- two rows: 1,3
select * from generate_series(1,3,2);
 generate_series 
-----------------
               1
               3
(2 rows)

-- zero rows
select * from generate_series(1,3,-1);
 generate_series 
-----------------
(0 rows)

-- zero rows
select * from generate_series(3,1);
 generate_series 
-----------------
(0 rows)

-- zero rows
select * from generate_series(3,1,1);
 generate_series 
-----------------
(0 rows)

-- zero rows
select * from generate_series(1,3,0);
 generate_series 
-----------------
(0 rows)

-- three rows: 3,2,1
select * from generate_series(3,1,-1);
 generate_series 
-----------------
               3
               2
               1
(3 rows)

-- two rows: 3,1
select * from generate_series(3,1,-2);
 generate_series 
-----------------
               3
               1
(2 rows)

-- three rows: -3,-2,-1
select * from generate_series(-3,-1,1);
 generate_series 
-----------------
              -3
              -2
              -1
(3 rows)

-- three rows: 80000000001,80000000002,80000000003
select * from generate_series(80000000001,80000000003);
 generate_series 
-----------------
     80000000001
     80000000002
     80000000003
(3 rows)

-- zero rows
select * from generate_series(80000000001,80000000003,0);
 generate_series 
-----------------
(0 rows)

-- three rows: 80000000001,80000000002,80000000003
select * from generate_series(80000000001,80000000003,1);
 generate_series 
-----------------
     80000000001
     80000000002
     80000000003
(3 rows)

-- two rows: 80000000001,80000000003
select * from generate_series(80000000001,80000000003,2);
 generate_series 
-----------------
     80000000001
     80000000003
(2 rows)

-- zero rows
select * from generate_series(80000000001,80000000003,-1);
 generate_series 
-----------------
(0 rows)

-- zero rows
select * from generate_series(80000000003,80000000001);
 generate_series 
-----------------
(0 rows)

-- zero rows
select * from generate_series(80000000003,80000000001,1);
 generate_series 
-----------------
(0 rows)

-- three rows: 80000000003,80000000002,80000000001
select * from generate_series(80000000003,80000000001,-1);
 generate_series 
-----------------
     80000000003
     80000000002
     80000000001
(3 rows)

-- two rows: 80000000003,80000000001
select * from generate_series(80000000003,80000000001,-2);
 generate_series 
-----------------
     80000000003
     80000000001
(2 rows)

-- three rows: -80000000003,-80000000002,-80000000001
select * from generate_series(-80000000003,-80000000001,1);
 generate_series 
-----------------
    -80000000003
    -80000000002
    -80000000001
(3 rows)