Cleanup around json_to_record/json_to_recordset
Andrew Dunstan <andrew@dunslane.net>
Cleanup around json_to_record/json_to_recordset Set function parameter names and defaults. Add jsonb versions (which the code already provided for so the actual new code is trivial). Add jsonb regression tests and docs. Bump catalog version (which I apparently forgot to do when jsonb was committed).
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +12 −6 |
| src/backend/catalog/system_views.sql | modified | +16 −0 |
| src/backend/utils/adt/jsonfuncs.c | modified | +24 −12 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +4 −0 |
| src/include/utils/json.h | modified | +2 −0 |
| src/test/regress/expected/jsonb_1.out | modified | +16 −0 |
| src/test/regress/expected/jsonb.out | modified | +16 −0 |
| src/test/regress/sql/jsonb.sql | modified | +8 −0 |