Statics§
- _LINKME_
ELEMENT_ 🔒jsonb_ populate_ map_ anymap_ jsonb_ anymap - _LINKME_
ELEMENT_ 🔒jsonb_ populate_ record_ struct_ jsonb_ struct - _LINKME_
ELEMENT_ 🔒jsonb_ populate_ recordset_ struct_ jsonb_ struct - _LINKME_
ELEMENT_ 🔒jsonb_ to_ record_ jsonb_ struct - _LINKME_
ELEMENT_ 🔒jsonb_ to_ recordset_ jsonb_ struct
Functions§
- jsonb_
populate_ map - jsonb_
populate_ 🔒map_ anymap_ jsonb_ anymap - jsonb_
populate_ 🔒record - Expands the top-level JSON object to a row having the composite type of the base argument. The JSON object is scanned for fields whose names match column names of the output row type, and their values are inserted into those columns of the output. (Fields that do not correspond to any output column name are ignored.) In typical use, the value of base is just NULL, which means that any output columns that do not match any object field will be filled with nulls. However, if base isn’t NULL then the values it contains will be used for unmatched columns.
- jsonb_
populate_ 🔒record_ struct_ jsonb_ struct - jsonb_
populate_ 🔒recordset - Expands the top-level JSON array of objects to a set of rows having the composite type of the
base argument. Each element of the JSON array is processed as described above for
jsonb_populate_record. - jsonb_
populate_ 🔒recordset_ struct_ jsonb_ struct - jsonb_
to_ 🔒record - Expands the top-level JSON object to a row having the composite type defined by an AS clause.
The output record is filled from fields of the JSON object, in the same way as described above
for
jsonb_populate_record. Since there is no input record value, unmatched columns are always filled with nulls. - jsonb_
to_ 🔒record_ jsonb_ struct - jsonb_
to_ 🔒recordset - Expands the top-level JSON array of objects to a set of rows having the composite type defined
by an AS clause. Each element of the JSON array is processed as described above for
jsonb_populate_record. - jsonb_
to_ 🔒recordset_ jsonb_ struct - parse_
err 🔒 - Construct a parse error from String.