File tree 6 files changed +166
-4200
lines changed
Filter options
6 files changed +166
-4200
lines changed
Original file line number Diff line number Diff line change @@ -830,6 +830,37 @@ select '"XXX"'::jsonb @@ '#.$="XXX"';
830
830
f
831
831
(1 row)
832
832
833
+ --Unicode
834
+ select 'a\t = "dollar \u0024 character"'::jsquery;
835
+ jsquery
836
+ ------------------------------
837
+ "a\t" = "dollar $ character"
838
+ (1 row)
839
+
840
+ select '{ "a": "dollar \u0024 character" }'::jsonb @@ '* = "dollar \u0024 character"';
841
+ ?column?
842
+ ----------
843
+ t
844
+ (1 row)
845
+
846
+ select '{ "a": "dollar \u0024 character" }'::jsonb @@ '* = "dollar $ character"';
847
+ ?column?
848
+ ----------
849
+ t
850
+ (1 row)
851
+
852
+ select '{ "a": "dollar $ character" }'::jsonb @@ '* = "dollar \u0024 character"';
853
+ ?column?
854
+ ----------
855
+ t
856
+ (1 row)
857
+
858
+ select 'a\r = "\n\""'::jsquery;
859
+ jsquery
860
+ ----------------
861
+ "a\r" = "\n\""
862
+ (1 row)
863
+
833
864
---table and index
834
865
select count(*) from test_jsquery where (v->>'review_helpful_votes')::int4 > 0;
835
866
count
You can’t perform that action at this time.
0 commit comments