The solarcommon.ant_pattern_to_regexp(text) database function can produce a regular expression that does not correctly match to a collapsed path segment. For example this fails to match when it should:

SELECT '/foo/bar.1' ~ solarcommon.ant_pattern_to_regexp('/foo/**/*.1');

That should return TRUE but incorrectly returns FALSE. When testing with a subpath segment, the correct result is returned:

SELECT '/foo/bar/baz.1' ~  solarcommon.ant_pattern_to_regexp('/foo/**/*.1');