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
NOTICE: ('import socket failed -- No module named foosocket',)
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, lname: doe, userid: 1, username: j_doe}
60
john doe => {fname: john, lname: doe, userid: 2, username: johnd}
61
willem doe => {fname: willem, lname: doe, userid: 3, 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';
152
SELECT newline_crlf();