json_typeof
Enterprise scalar function reference.
Function Snapshot
| Field | Value |
|---|---|
| Function | json_typeof |
| Category | JSON and Object |
| Scope | Scalar expression |
| Discovery | SELECT * FROM pg_catalog.pg_proc WHERE proname = 'json_typeof'; |
Purpose
Returns JSON type classification such as object, array, string, number, or boolean.
Syntax
SELECT json_typeof(...);
Parameters
- Positional arguments as defined by overload signatures in pg_catalog.pg_proc.
Returns
- Returns type label text.
Null and Error Behavior
- Most overloads are deterministic and null-propagating unless documented otherwise.
- Validate concrete overload behavior with pg_catalog.pg_proc in your running build.
Operational Notes
- Use schema-qualified objects and parameterized queries for production pipelines.
- Validate overload details in-cluster with pg_catalog.pg_proc and pg_get_function_result(oid).