The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ltree.html Description:
In v12 ltree doc (I've not checked other versions) "The behavior of % is a bit complicated. It tries to match words rather than the entire label. For example foo_bar% matches foo_bar_baz but not foo_barbaz. If combined with *, prefix matching applies to each word separately, for example foo_bar%* matches foo1_bar2_baz but not foo1_br2_baz. I believe foo1 is in error (if I understood the operators), it should be foo. Regards T
