Documentation: Unrelating a relation

[IngwiePhoenix]

Description

So once you did

RELATE user:ingwie->likes->post:abcdef;

...how do you un-relate?

I first thought of making this a feature request for an UNRELATE keyword, but I am pretty sure there is an existing way to this. And, I would love this to be documented. :)

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct

[coldino]

This is asked frequently so I'm looking forward to it being documented.

The relation is basically just a table called likes with an in and an out so you can delete it as normal:

DELETE likes WHERE in=user:ingwie AND out=post:abcdef;

But as pointed out in this Discord post from Tobie, it's more efficient to use the relation itself to find the links to delete:

DELETE FROM user:ingwie->likes WHERE out=post:abcdef;

There are plenty more examples in the Discord until the docs are fully fleshed out!

As an aside, you can use the fact that it's just a table to make it SCHEMAFULL and restrict the relation types.

[IngwiePhoenix]

Oh believe me, last night I went ham on those =) I am quite aware of them just being a table and was trying out if I can relate just one or many types or... well, let's just say I experimented a good few hours on this feature alone!

Thanks for sharing the example; feels honestly a little unintuitive compared to just a plain UNRELATE keyword. But, this'll do untill then!

[postmeback]

I believe this issue can be closed.