Database & utility Scalar

remap_struct()

Map a struct to another struct type, potentially re-ordering, renaming and casting members and filling in defaults for missing values

Arguments & returns

Scalar

Overload link	`input`	`target_type`	`mapping`	`defaults`	Returns
#01	`ANY`	`ANY`	`ANY`	`ANY`	`ANY`

SELECT remap_struct({'i': 1, 'j': 2}, NULL::ROW(v1 INT, v2 INT, v3 INT), {'v1': 'j', 'v3': 'i'}, {'v2': NULL::INTEGER});

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.