diff options
author | Peter Eisentraut <peter_e@gmx.net> | 2013-05-30 21:05:07 -0400 |
---|---|---|
committer | Peter Eisentraut <peter_e@gmx.net> | 2013-05-30 21:05:07 -0400 |
commit | 8b5a3998a104ef5918b50e207be0aa86e085d49d (patch) | |
tree | ccdab0f574946f918f40cdf5681782f647e2e3f4 /src/test | |
parent | d7eb6f46de900f6664918cda3b5e6f922a0a2356 (diff) | |
download | postgresql-8b5a3998a104ef5918b50e207be0aa86e085d49d.tar.gz |
Remove whitespace from end of lines
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/regress/expected/json.out | 12 | ||||
-rw-r--r-- | src/test/regress/sql/json.sql | 12 |
2 files changed, 12 insertions, 12 deletions
diff --git a/src/test/regress/expected/json.out b/src/test/regress/expected/json.out index 01f0679c87..1d7cf5ff2f 100644 --- a/src/test/regress/expected/json.out +++ b/src/test/regress/expected/json.out @@ -466,15 +466,15 @@ INSERT INTO test_json VALUES ('scalar','"a scalar"'), ('array','["zero", "one","two",null,"four","five"]'), ('object','{"field1":"val1","field2":"val2","field3":null}'); -SELECT test_json -> 'x' +SELECT test_json -> 'x' FROM test_json WHERE json_type = 'scalar'; ERROR: cannot extract element from a scalar -SELECT test_json -> 'x' +SELECT test_json -> 'x' FROM test_json WHERE json_type = 'array'; ERROR: cannot extract field from a non-object -SELECT test_json -> 'x' +SELECT test_json -> 'x' FROM test_json WHERE json_type = 'object'; ?column? @@ -490,7 +490,7 @@ WHERE json_type = 'object'; "val2" (1 row) -SELECT test_json->>'field2' +SELECT test_json->>'field2' FROM test_json WHERE json_type = 'object'; ?column? @@ -498,11 +498,11 @@ WHERE json_type = 'object'; val2 (1 row) -SELECT test_json -> 2 +SELECT test_json -> 2 FROM test_json WHERE json_type = 'scalar'; ERROR: cannot extract element from a scalar -SELECT test_json -> 2 +SELECT test_json -> 2 FROM test_json WHERE json_type = 'array'; ?column? diff --git a/src/test/regress/sql/json.sql b/src/test/regress/sql/json.sql index 04b22fe297..8a136d7a27 100644 --- a/src/test/regress/sql/json.sql +++ b/src/test/regress/sql/json.sql @@ -139,15 +139,15 @@ INSERT INTO test_json VALUES ('array','["zero", "one","two",null,"four","five"]'), ('object','{"field1":"val1","field2":"val2","field3":null}'); -SELECT test_json -> 'x' +SELECT test_json -> 'x' FROM test_json WHERE json_type = 'scalar'; -SELECT test_json -> 'x' +SELECT test_json -> 'x' FROM test_json WHERE json_type = 'array'; -SELECT test_json -> 'x' +SELECT test_json -> 'x' FROM test_json WHERE json_type = 'object'; @@ -155,15 +155,15 @@ SELECT test_json->'field2' FROM test_json WHERE json_type = 'object'; -SELECT test_json->>'field2' +SELECT test_json->>'field2' FROM test_json WHERE json_type = 'object'; -SELECT test_json -> 2 +SELECT test_json -> 2 FROM test_json WHERE json_type = 'scalar'; -SELECT test_json -> 2 +SELECT test_json -> 2 FROM test_json WHERE json_type = 'array'; |