@@ -1617,7 +1617,11 @@ def _generate_series_sql(self: Generator, expression: exp.GenerateSeries) -> str
         if expression.args.get("is_end_exclusive"):
             if exclusive_func_name:
                 return self.func(exclusive_func_name, start, end, step)
-            adjusted_end = exp.Sub(this=end, expression=exp.Literal.number(1))
+            # The last value is one before the end in the direction of the step
+            if step and step.is_int and t.cast(int, step.to_py()) < 0:
+                adjusted_end: exp.Expr = exp.Add(this=end, expression=exp.Literal.number(1))
+            else:
+                adjusted_end = exp.Sub(this=end, expression=exp.Literal.number(1))
             return self.func(func_name, start, adjusted_end, step)
 
         return self.func(func_name, start, end, step)
 
@@ -400,7 +400,9 @@ def test_duckdb(self):
         self.validate_all(
             "SELECT RANGE(5, 1, -1)",
             write={
+                "bigquery": "SELECT GENERATE_ARRAY(5, 1 + 1, -1)",
                 "duckdb": "SELECT RANGE(5, 1, -1)",
+                "postgres": "SELECT GENERATE_SERIES(5, 1 + 1, -1)",
                 "spark": "SELECT SEQUENCE(5, 2, -1)",
                 "snowflake": "SELECT ARRAY_GENERATE_RANGE(5, 1, -1)",
             },