Home
last modified time | relevance | path

Searched refs:json_array_length (Results 1 – 25 of 314) sorted by relevance

12345678910>>...13

/dports/databases/py-sqlalchemy-utils/SQLAlchemy-Utils-0.37.9/sqlalchemy_utils/
H A Dexpressions.py43 class json_array_length(GenericFunction): class
48 @compiles(json_array_length, 'postgresql')
/dports/databases/sqlite3/sqlite-src-3350500/test/
H A Djson102.test54 SELECT json_array_length('[1,2,3,4]');
57 SELECT json_array_length('[1,2,3,4]', '$');
60 SELECT json_array_length('[1,2,3,4]', '$[2]');
63 SELECT json_array_length('{"one":[1,2,3]}');
66 SELECT json_array_length('{"one":[1,2,3]}', '$.one');
69 SELECT json_array_length('{"one":[1,2,3]}', '$.two');
203 WHERE json_array_length(phone)<2;
/dports/databases/sqlcipher/sqlcipher-3.4.2/test/
H A Djson102.test54 SELECT json_array_length('[1,2,3,4]');
57 SELECT json_array_length('[1,2,3,4]', '$');
60 SELECT json_array_length('[1,2,3,4]', '$[2]');
63 SELECT json_array_length('{"one":[1,2,3]}');
66 SELECT json_array_length('{"one":[1,2,3]}', '$.one');
69 SELECT json_array_length('{"one":[1,2,3]}', '$.two');
203 WHERE json_array_length(phone)<2;
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/test/
H A Djson102.test54 SELECT json_array_length('[1,2,3,4]');
57 SELECT json_array_length('[1,2,3,4]', '$');
60 SELECT json_array_length('[1,2,3,4]', '$[2]');
63 SELECT json_array_length('{"one":[1,2,3]}');
66 SELECT json_array_length('{"one":[1,2,3]}', '$.one');
69 SELECT json_array_length('{"one":[1,2,3]}', '$.two');
203 WHERE json_array_length(phone)<2;
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/
H A Djson.sql282 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
284 SELECT json_array_length('[]');
286 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
288 SELECT json_array_length('4');
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Djson.sql624 json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
627 json_array_length('[]');
630 json_array_length('{"f1":1,"f2":[5,6]}');
633 json_array_length('4');
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Djson.sql288 SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
290 SELECT json_array_length('[]');
292 SELECT json_array_length('{"f1":1,"f2":[5,6]}');
294 SELECT json_array_length('4');

12345678910>>...13