> > If you count carefully, you will see that regexp_matches() reports a > match of the pattern at the start of the string and at the end of the > string, and also just before 'c' (after the match to the single space). > However, regexp_split() disregards these "degenerate" matches of the > same pattern. > > Is this what we want? Arguably regexp_split is doing the most > reasonable thing for its intended usage, but the strict definition of > regexp matching seems to require what regexp_matches does. I think > we need to either change one function to match the other, or else > document the inconsistency. >
Regexp_matches behave is correct, but less usable. I thing space from virtual begin to first char and from last char to virtual end can be eliminated. Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match