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
