diff options
Diffstat (limited to 'src/pl/tcl/sql/pltcl_queries.sql')
| -rw-r--r-- | src/pl/tcl/sql/pltcl_queries.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/pl/tcl/sql/pltcl_queries.sql b/src/pl/tcl/sql/pltcl_queries.sql index ee711d5170..205bc4266a 100644 --- a/src/pl/tcl/sql/pltcl_queries.sql +++ b/src/pl/tcl/sql/pltcl_queries.sql @@ -82,3 +82,18 @@ delete from trigger_test_view; update trigger_test set v = 'update' where i = 1; delete from trigger_test; + +-- Test composite-type arguments +select tcl_composite_arg_ref1(row('tkey', 42, 'ref2')); +select tcl_composite_arg_ref2(row('tkey', 42, 'ref2')); + +-- Test argisnull primitive +select tcl_argisnull('foo'); +select tcl_argisnull(''); +select tcl_argisnull(null); + +-- Test spi_lastoid primitive +create temp table t1 (f1 int); +select tcl_lastoid('t1'); +create temp table t2 (f1 int) with oids; +select tcl_lastoid('t2') > 0; |
