diff options
Diffstat (limited to 'src/test/regress/sql/plpgsql.sql')
-rw-r--r-- | src/test/regress/sql/plpgsql.sql | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql index 49223ff2b92..e7445be1896 100644 --- a/src/test/regress/sql/plpgsql.sql +++ b/src/test/regress/sql/plpgsql.sql @@ -3719,6 +3719,7 @@ drop function tftest(int); create or replace function rttest() returns setof int as $$ declare rc int; + rca int[]; begin return query values(10),(20); get diagnostics rc = row_count; @@ -3727,11 +3728,12 @@ begin get diagnostics rc = row_count; raise notice '% %', found, rc; return query execute 'values(10),(20)'; - get diagnostics rc = row_count; - raise notice '% %', found, rc; + -- just for fun, let's use array elements as targets + get diagnostics rca[1] = row_count; + raise notice '% %', found, rca[1]; return query execute 'select * from (values(10),(20)) f(a) where false'; - get diagnostics rc = row_count; - raise notice '% %', found, rc; + get diagnostics rca[2] = row_count; + raise notice '% %', found, rca[2]; end; $$ language plpgsql; |