Delete prop on a object field when it is null

[calebeaires]

Given this row

CREATE person:someId SET metadata = {
	interest_level: 83.67,
	information: {
		age: 23,
		gender: 'm',
	},
	marketing: true
};

I would like to "delete" a prop inside a object schema doing so:

UPDATE person:someId SET information.gender = null

SurrealDB update the object an set the information.gender nullable, but my primary intention where to "delete the prop".

What SurrealDB do

{
	interest_level: 83.67,
	information: {
		age: 23,
		gender: null,
	},
	marketing: true
}

But this is the need:

{
	interest_level: 83.67,
	information: {
		age: 23
	},
	marketing: true
}

[tobiemh]

Hi @calebeaires you can set the field to NONE to delete it entirely...

UPDATE person:someId SET information.gender = NONE;