diff options
Diffstat (limited to 'src/pl/plpython/sql/plpython_spi.sql')
| -rw-r--r-- | src/pl/plpython/sql/plpython_spi.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/pl/plpython/sql/plpython_spi.sql b/src/pl/plpython/sql/plpython_spi.sql index 874b31e6df6..b828744d1f8 100644 --- a/src/pl/plpython/sql/plpython_spi.sql +++ b/src/pl/plpython/sql/plpython_spi.sql @@ -95,10 +95,13 @@ SELECT join_sequences(sequences) FROM sequences CREATE FUNCTION result_nrows_test() RETURNS int AS $$ -plan = plpy.prepare("SELECT 1 UNION SELECT 2") +plan = plpy.prepare("SELECT 1 AS foo, '11'::text AS bar UNION SELECT 2, '22'") plpy.info(plan.status()) # not really documented or useful result = plpy.execute(plan) if result.status() > 0: + plpy.info(result.colnames()) + plpy.info(result.coltypes()) + plpy.info(result.coltypmods()) return result.nrows() else: return None |