aboutsummaryrefslogtreecommitdiff
path: root/src/pl/plpython/expected/plpython_spi.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/pl/plpython/expected/plpython_spi.out')
-rw-r--r--src/pl/plpython/expected/plpython_spi.out15
1 files changed, 15 insertions, 0 deletions
diff --git a/src/pl/plpython/expected/plpython_spi.out b/src/pl/plpython/expected/plpython_spi.out
index e715ee5393b..dbde36f8412 100644
--- a/src/pl/plpython/expected/plpython_spi.out
+++ b/src/pl/plpython/expected/plpython_spi.out
@@ -57,6 +57,15 @@ for r in rv:
return seq
'
LANGUAGE plpythonu;
+CREATE FUNCTION spi_recursive_sum(a int) RETURNS int
+ AS
+'r = 0
+if a > 1:
+ r = plpy.execute("SELECT spi_recursive_sum(%d) as a" % (a-1))[0]["a"]
+return a + r
+'
+ LANGUAGE plpythonu;
+--
-- spi and nested calls
--
select nested_call_one('pass this along');
@@ -112,6 +121,12 @@ SELECT join_sequences(sequences) FROM sequences
----------------
(0 rows)
+SELECT spi_recursive_sum(10);
+ spi_recursive_sum
+-------------------
+ 55
+(1 row)
+
--
-- plan and result objects
--