@@ -466,15 +466,15 @@ INSERT INTO test_json VALUES
466
466
('scalar','"a scalar"'),
467
467
('array','["zero", "one","two",null,"four","five"]'),
468
468
('object','{"field1":"val1","field2":"val2","field3":null}');
469
- SELECT test_json -> 'x'
469
+ SELECT test_json -> 'x'
470
470
FROM test_json
471
471
WHERE json_type = 'scalar';
472
472
ERROR: cannot extract element from a scalar
473
- SELECT test_json -> 'x'
473
+ SELECT test_json -> 'x'
474
474
FROM test_json
475
475
WHERE json_type = 'array';
476
476
ERROR: cannot extract field from a non-object
477
- SELECT test_json -> 'x'
477
+ SELECT test_json -> 'x'
478
478
FROM test_json
479
479
WHERE json_type = 'object';
480
480
?column?
@@ -490,19 +490,19 @@ WHERE json_type = 'object';
490
490
"val2"
491
491
(1 row)
492
492
493
- SELECT test_json->>'field2'
493
+ SELECT test_json->>'field2'
494
494
FROM test_json
495
495
WHERE json_type = 'object';
496
496
?column?
497
497
----------
498
498
val2
499
499
(1 row)
500
500
501
- SELECT test_json -> 2
501
+ SELECT test_json -> 2
502
502
FROM test_json
503
503
WHERE json_type = 'scalar';
504
504
ERROR: cannot extract element from a scalar
505
- SELECT test_json -> 2
505
+ SELECT test_json -> 2
506
506
FROM test_json
507
507
WHERE json_type = 'array';
508
508
?column?