diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/plpgsql.out | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/plpgsql.sql | 6 |
2 files changed, 7 insertions, 7 deletions
diff --git a/src/test/regress/expected/plpgsql.out b/src/test/regress/expected/plpgsql.out index ff1a9604df7..4a93ee24148 100644 --- a/src/test/regress/expected/plpgsql.out +++ b/src/test/regress/expected/plpgsql.out @@ -2985,8 +2985,8 @@ DROP FUNCTION nonsimple_expr_test(); create function recurse(float8) returns float8 as $$ begin - if ($1 < 10) then - return sql_recurse($1 + 1); + if ($1 > 0) then + return sql_recurse($1 - 1); else return $1; end if; @@ -2995,10 +2995,10 @@ $$ language plpgsql; -- "limit" is to prevent this from being inlined create function sql_recurse(float8) returns float8 as $$ select recurse($1) limit 1; $$ language sql; -select recurse(0); +select recurse(5); recurse --------- - 10 + 0 (1 row) create function error1(text) returns text language sql as diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql index 37bdb72fb7e..ea7aa129f15 100644 --- a/src/test/regress/sql/plpgsql.sql +++ b/src/test/regress/sql/plpgsql.sql @@ -2490,8 +2490,8 @@ DROP FUNCTION nonsimple_expr_test(); create function recurse(float8) returns float8 as $$ begin - if ($1 < 10) then - return sql_recurse($1 + 1); + if ($1 > 0) then + return sql_recurse($1 - 1); else return $1; end if; @@ -2502,7 +2502,7 @@ $$ language plpgsql; create function sql_recurse(float8) returns float8 as $$ select recurse($1) limit 1; $$ language sql; -select recurse(0); +select recurse(5); create function error1(text) returns text language sql as $$ SELECT relname::text FROM pg_class c WHERE c.oid = $1::regclass $$; |