regress/sql/text.sql

59 select format(NULL);
60 select format('Hello');
61 select format('Hello %s', 'World');
62 select format('Hello %%');
63 select format('Hello %%%%');
65 select format('Hello %s %s', 'World');
66 select format('Hello %s');
67 select format('Hello %x', 20);
69 select format('INSERT INTO %I VALUES(%L,%L)', 'mytab', 10, 'Hello');
70 select format('%s%s%s','Hello', NULL,'World');
71 select format('INSERT INTO %I VALUES(%L,%L)', 'mytab', 10, NULL);
72 select format('INSERT INTO %I VALUES(%L,%L)', 'mytab', NULL, 'Hello');
74 select format('INSERT INTO %I VALUES(%L,%L)', NULL, 10, 'Hello');
76 select format('%1$s %3$s', 1, 2, 3);
77 select format('%1$s %12$s', 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12);
79 select format('%1$s %4$s', 1, 2, 3);
80 select format('%1$s %13$s', 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12);
81 select format('%0$s', 'Hello');
82 select format('%*0$s', 'Hello');
83 select format('%1$', 1);
84 select format('%1$1', 1);
86 select format('Hello %s %1$s %s', 'World', 'Hello again');
87 select format('Hello %s %s, %2$s %2$s', 'World', 'Hello again');
89 select format('%s, %s', variadic array['Hello','World']);
90 select format('%s, %s', variadic array[1, 2]);
91 select format('%s, %s', variadic array[true, false]);
92 select format('%s, %s', variadic array[true, false]::text[]);
94 select format('%2$s, %1$s', variadic array['first', 'second']);
95 select format('%2$s, %1$s', variadic array[1, 2]);
97 select format('Hello', variadic NULL::int[]);
99 select format(string_agg('%s',','), variadic array_agg(i))
102 select format('>>%10s<<', 'Hello');
103 select format('>>%10s<<', NULL);
104 select format('>>%10s<<', '');
105 select format('>>%-10s<<', '');
106 select format('>>%-10s<<', 'Hello');
107 select format('>>%-10s<<', NULL);
108 select format('>>%1$10s<<', 'Hello');
109 select format('>>%1$-10I<<', 'Hello');
110 select format('>>%2$*1$L<<', 10, 'Hello');
111 select format('>>%2$*1$L<<', 10, NULL);
112 select format('>>%2$*1$L<<', -10, NULL);
113 select format('>>%*s<<', 10, 'Hello');
114 select format('>>%*1$s<<', 10, 'Hello');
115 select format('>>%-s<<', 'Hello');
116 select format('>>%10L<<', NULL);
117 select format('>>%2$*1$L<<', NULL, 'Hello');
118 select format('>>%2$*1$L<<', 0, 'Hello');