How to check if a node is repeated (exits more than one) in a ltree?
Something like this:
'0.1.2.3.4.3.9' ==> True
'0.1.2.3.4.5.9' ==> False
How to check if a node is repeated (exits more than one) in a ltree?
Something like this:
'0.1.2.3.4.3.9' ==> True
'0.1.2.3.4.5.9' ==> False
Copyright © 2021 Jogjafile Inc.
Convert it to a string, split that into a table and check if there are duplicate entries:
A better option may be a smart regular expression, based on your comment: