1 -- Load the TAP functions.
7 SELECT is(public.text_concat('foo','bar'), 'foo bar', '2 Strings');
8 SELECT is(public.text_concat('åbçdéñœöîøæ', 'ÇıÂÅÍÎÏÔÔÒÚÆŒè'),
9 'åbçdéñœöîøæ ÇıÂÅÍÎÏÔÔÒÚÆŒè', '2 More Strings');
10 SELECT is(public.text_concat('foo',NULL), 'foo', 'string + NULL');
11 SELECT is(public.text_concat(NULL, 'bar'), 'bar', 'NULL + string');
12 SELECT is(public.text_concat(NULL, NULL), NULL, 'NULL + NULL');
16 INSERT INTO config.billing_type (name, owner, default_price) VALUES
17 ('pgtap 1', 1, DEFAULT),
18 ('pgtap 2', 1, '3.34'),
19 ('pgtap 3', 1, '4.56');
22 (SELECT agg_text(subq.default_price::text) FROM
23 (SELECT * FROM config.billing_type
24 WHERE name ~ 'pgtap' ORDER BY name) subq),
26 'agg_text() aggregates some text'
29 -- Finish the tests and clean up.
30 SELECT * FROM finish();