1 -- Start transaction and plan the tests.
6 SELECT is(evergreen.lpad_number_substrings(
7 'Appendix','0',5), 'Appendix','Non-numeric string');
9 SELECT is(evergreen.lpad_number_substrings(
10 'DISC 11','0',5), 'DISC 00011','Prefix, 1 number');
12 SELECT is(evergreen.lpad_number_substrings(
13 'DISC 14.1','0',5), 'DISC 00014.00001','Prefix, 2 numbers');
15 SELECT is(evergreen.lpad_number_substrings(
16 'DISC 12.12.13','0',5), 'DISC 00012.00012.00013','Prefix, 3 numbers');
18 SELECT is(evergreen.lpad_number_substrings(
19 'Vol 5a-15','0',5), 'Vol 00005a-00015','Mixed format');
21 SELECT isnt(evergreen.lpad_number_substrings(
22 '2015 01 Jan','0',5),'02000015 00001 Jan','Matching Substring Error 1');
24 SELECT isnt(evergreen.lpad_number_substrings(
25 '2015 02 Feb','0',5),'00002015 00002 Feb','Matching Substring Error 2');
27 SELECT is(evergreen.lpad_number_substrings(
28 '2015 01 Jan','0',5),'02015 00001 Jan','Matching Substrings 1');
30 SELECT is(evergreen.lpad_number_substrings(
31 '2015 02 Feb','0',5),'02015 00002 Feb','Matching Substrings 2');
33 SELECT is(evergreen.lpad_number_substrings(
34 '0001 001 1 01','0',5),'00001 00001 00001 00001','Matching Substrings 3');
36 SELECT is(evergreen.lpad_number_substrings(
37 '123456','0',5),'123456','Longer than Padding Length');
39 -- Finish the tests and clean up.
40 SELECT * FROM finish();