Function Category: JSON Functions

array_to_json() — PostgreSQL JSON function

array_to_json(): map array to json. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

bool() — PostgreSQL JSON function

bool(): convert jsonb to boolean. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

float4() — PostgreSQL JSON function

float4(): convert int2 to float4. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

float8() — PostgreSQL JSON function

float8(): convert int2 to float8. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

int2() — PostgreSQL JSON function

int2(): convert float8 to int2. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

int4() — PostgreSQL JSON function

int4(): convert char to int4. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

int8() — PostgreSQL JSON function

int8(): convert bytea to int8. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

json_array_length() — PostgreSQL JSON function

json_array_length(): length of json array. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

json_build_array() — PostgreSQL JSON function

json_build_array(): build an empty json array. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.

json_build_object() — PostgreSQL JSON function

json_build_object(): build an empty json object. PostgreSQL json functions — signature, volatility, version applicability and an illustrative example.