Home
last modified time | relevance | path

Searched refs:jsonb_path_match (Results 1 – 25 of 170) sorted by relevance

1234567

/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Djsonb_jsonpath.sql369 SELECT jsonb_path_match('true', '$', silent => false);
370 SELECT jsonb_path_match('false', '$', silent => false);
371 SELECT jsonb_path_match('null', '$', silent => false);
372 SELECT jsonb_path_match('1', '$', silent => true);
373 SELECT jsonb_path_match('1', '$', silent => false);
374 SELECT jsonb_path_match('"a"', '$', silent => false);
375 SELECT jsonb_path_match('{}', '$', silent => false);
376 SELECT jsonb_path_match('[true]', '$', silent => false);
377 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
378 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Djsonb_jsonpath.sql983 jsonb_path_match('true', '$', silent => FALSE);
986 jsonb_path_match('false', '$', silent => FALSE);
989 jsonb_path_match('null', '$', silent => FALSE);
992 jsonb_path_match('1', '$', silent => TRUE);
995 jsonb_path_match('1', '$', silent => FALSE);
998 jsonb_path_match('"a"', '$', silent => FALSE);
1001 jsonb_path_match('{}', '$', silent => FALSE);
1004 jsonb_path_match('[true]', '$', silent => FALSE);
1007 jsonb_path_match('{}', 'lax $.a', silent => FALSE);
1010 jsonb_path_match('{}', 'strict $.a', silent => FALSE);
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/
H A Djsonb_jsonpath.sql376 SELECT jsonb_path_match('true', '$', silent => false);
377 SELECT jsonb_path_match('false', '$', silent => false);
378 SELECT jsonb_path_match('null', '$', silent => false);
379 SELECT jsonb_path_match('1', '$', silent => true);
380 SELECT jsonb_path_match('1', '$', silent => false);
381 SELECT jsonb_path_match('"a"', '$', silent => false);
382 SELECT jsonb_path_match('{}', '$', silent => false);
383 SELECT jsonb_path_match('[true]', '$', silent => false);
384 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
385 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/
H A Djsonb_jsonpath.sql557 SELECT jsonb_path_match('true', '$', silent => false);
558 SELECT jsonb_path_match('false', '$', silent => false);
559 SELECT jsonb_path_match('null', '$', silent => false);
560 SELECT jsonb_path_match('1', '$', silent => true);
561 SELECT jsonb_path_match('1', '$', silent => false);
562 SELECT jsonb_path_match('"a"', '$', silent => false);
563 SELECT jsonb_path_match('{}', '$', silent => false);
564 SELECT jsonb_path_match('[true]', '$', silent => false);
565 SELECT jsonb_path_match('{}', 'lax $.a', silent => false);
566 SELECT jsonb_path_match('{}', 'strict $.a', silent => false);
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/expected/
H A Djsonb_jsonpath.out1212 jsonb_path_match
1218 jsonb_path_match
1224 jsonb_path_match
1230 jsonb_path_match
1236 jsonb_path_match
1242 jsonb_path_match
1770 jsonb_path_match
1776 jsonb_path_match
1782 jsonb_path_match
1788 jsonb_path_match
[all …]
/dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/expected/
H A Djsonb_jsonpath.out1212 jsonb_path_match
1218 jsonb_path_match
1224 jsonb_path_match
1230 jsonb_path_match
1236 jsonb_path_match
1242 jsonb_path_match
1770 jsonb_path_match
1776 jsonb_path_match
1782 jsonb_path_match
1788 jsonb_path_match
[all …]

1234567