19 SELECT global_test_one();
21 --------------------------------------------------------
22 SD: set by global_test_one, GD: set by global_test_one
25 SELECT global_test_two();
27 --------------------------------------------------------
28 SD: set by global_test_two, GD: set by global_test_one
32 WARNING: ('import socket failed -- untrusted dynamic module: _socket',)
38 SELECT import_succeed();
40 ------------------------
41 succeeded, as expected
44 SELECT import_test_one('sha hash of this string');
46 ------------------------------------------
47 a04e23cb9b1a09cd1051a04a7c571aae0f90346c
50 select import_test_two(users) from users where fname = 'willem';
52 -------------------------------------------------------------------
53 sha hash of willemdoe is 3cde6b574953b0ca937b4d76ebc40d534d910759
56 select argument_test_one(users, fname, lname) from users where lname = 'doe' order by 1;
58 -------------------------------------------------------------------------------------
59 jane doe => {'fname': 'jane', 'userid': 1, 'lname': 'doe', 'username': 'j_doe'}
60 john doe => {'fname': 'john', 'userid': 2, 'lname': 'doe', 'username': 'johnd'}
61 willem doe => {'fname': 'willem', 'userid': 3, 'lname': 'doe', 'username': 'w_doe'}
64 select nested_call_one('pass this along');
66 -----------------------------------------------------------------
67 {'nested_call_two': "{'nested_call_three': 'pass this along'}"}
70 select spi_prepared_plan_test_one('doe');
71 spi_prepared_plan_test_one
72 ----------------------------
76 select spi_prepared_plan_test_one('smith');
77 spi_prepared_plan_test_one
78 ----------------------------
82 select spi_prepared_plan_test_nested('smith');
83 spi_prepared_plan_test_nested
84 -------------------------------
89 fname | lname | username | userid
90 --------+-------+----------+--------
91 jane | doe | j_doe | 1
92 john | doe | johnd | 2
93 willem | doe | w_doe | 3
94 rick | smith | slash | 4
97 UPDATE users SET fname = 'william' WHERE fname = 'willem';
98 INSERT INTO users (fname, lname) VALUES ('william', 'smith');
99 INSERT INTO users (fname, lname, username) VALUES ('charles', 'darwin', 'beagle');
101 fname | lname | username | userid
102 ---------+--------+----------+--------
103 jane | doe | j_doe | 1
104 john | doe | johnd | 2
105 willem | doe | w_doe | 3
106 rick | smith | slash | 4
107 willem | smith | w_smith | 5
108 charles | darwin | beagle | 6
111 SELECT join_sequences(sequences) FROM sequences;
122 SELECT join_sequences(sequences) FROM sequences
123 WHERE join_sequences(sequences) ~* '^A';
134 SELECT join_sequences(sequences) FROM sequences
135 WHERE join_sequences(sequences) ~* '^B';