summaryrefslogtreecommitdiff
path: root/expected/orig.out
blob: 95a768f220760b0e03b5517bd40e88d00a106e1e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
/* Make sure creating an array literal and subscripting
 * preserves the original string exactly
 * (except for trimming surrounding whitespace). */
SELECT bool_and(btrim(before, E'\t\n\r ') = after) FROM (
	SELECT
		string AS before,
		json_path(('  [ ' || string || '  ] ')::json, '$.[0]')::text AS after
	FROM valid_test_strings
) AS subquery;
 bool_and 
----------
 t
(1 row)