PostgreSQL 17beta1 A4 Documentationis also tested to see if it has duplicate keys. SELECT js, js IS JSON "json?", js IS JSON SCALAR "scalar?", js IS JSON OBJECT "object?", js IS JSON ARRAY "array?" FROM (VALUES ('123'), ('"abc"') ('"abc"'), ('{"a": "b"}'), ('[1,2]'), ('abc')) foo(js); js | json? | scalar? | object? | array? ------------+-------+---------+---------+-------- 123 | t | t | f | f "abc" | f | f | f | f SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array0 码力 | 3017 页 | 14.45 MB | 1 年前3- PostgreSQL 17beta1 US Documentationis also tested to see if it has duplicate keys. SELECT js, js IS JSON "json?", js IS JSON SCALAR "scalar?", js IS JSON OBJECT "object?", js IS JSON ARRAY "array?" FROM (VALUES ('123'), ('"abc"') ('"abc"'), ('{"a": "b"}'), ('[1,2]'),('abc')) foo(js); js | json? | scalar? | object? | array? ------------+-------+---------+---------+-------- 123 | t | t | f | f "abc" | f | f | f | f SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array0 码力 | 3188 页 | 14.32 MB | 1 年前3
- PostgreSQL 16.1 Documentationduplicate keys. SELECT js, js IS JSON "json?", js IS JSON SCALAR "scalar?", 346 Functions and Operators Function signature Description Example(s) js IS JSON OBJECT "object?", js IS JSON ARRAY "array "array?" FROM (VALUES ('123'), ('"abc"'), ('{"a": "b"}'), ('[1,2]'),('abc')) foo(js); js | json? | scalar? | object? | array? ------------+-------+---------+---------+-------- 123 | f | f | f | f SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array0 码力 | 3133 页 | 14.10 MB | 1 年前3
- PostgreSQL 16.1 Documentationduplicate keys. SELECT js, js IS JSON "json?", js IS JSON SCALAR "scalar?", 327 Functions and Operators Function signature Description Example(s) js IS JSON OBJECT "object?", js IS JSON ARRAY "array "array?" FROM (VALUES ('123'), ('"abc"'), ('{"a": "b"}'), ('[1,2]'), ('abc')) foo(js); js | json? | scalar? | object? | array? ------------+-------+---------+---------+-------- 123 | f | f | f | f SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array0 码力 | 2974 页 | 14.22 MB | 1 年前3
- PostgreSQL 9.4 Documentationhttps://jdbc.postgresql.org/ libpqxx C++ C++ interface http://pqxx.org/ node-postgres JavaScript Node.js driver https://node- postgres.com/ Npgsql .NET .NET data provider http://www.npgsql.org/ pgtcl Tcl0 码力 | 2603 页 | 6.05 MB | 1 年前3
- PostgreSQL 9.4.26 Documentation
https://jdbc.postgresql.org/ libpqxx C++ C++ interface http://pqxx.org/ node-postgres JavaScript Node.js driver https://node- postgres.com/ Npgsql .NET .NET data provider http://www.npgsql.org/ pgtcl Tcl0 码力 | 2452 页 | 5.99 MB | 1 年前3
- PostgreSQL 9.5.25 Documentation
https://jdbc.postgresql.org/ libpqxx C++ C++ interface https://pqxx.org/ node-postgres JavaScript Node.js driver https://node- postgres.com/ Npgsql .NET .NET data provider https://www.npgsql.org/ pgtcl Tcl0 码力 | 2558 页 | 6.27 MB | 1 年前3
- PostgreSQL 9.5 Documentationhttps://jdbc.postgresql.org/ libpqxx C++ C++ interface https://pqxx.org/ node-postgres JavaScript Node.js driver https://node- postgres.com/ Npgsql .NET .NET data provider https://www.npgsql.org/ pgtcl Tcl0 码力 | 2714 页 | 6.33 MB | 1 年前3
- PostgreSQL 10.23 Documentationhttps:// jdbc.postgresql.org/ libpqxx C++ C++ interface https://pqxx.org/ node-postgres JavaScript Node.js driver https://node- postgres.com/ Npgsql .NET .NET data provider https://www.npgsql.org/ pgtcl Tcl0 码力 | 2727 页 | 11.93 MB | 1 年前3
- PostgreSQL 10.23 Documentationhttps:// jdbc.postgresql.org/ libpqxx C++ C++ interface https://pqxx.org/ node-postgres JavaScript Node.js driver https://node- postgres.com/ Npgsql .NET .NET data provider https:// www.npgsql.org/ pgtcl0 码力 | 2590 页 | 12.03 MB | 1 年前3
共 16 条
- 1
- 2