Hi all, It must be that I haven't had enough caffeine today, but I can't figure out why the following expression captures the non-capturing part of the text:
# SELECT regexp_matches('postgres','(?:g)r'); regexp_matches ---------------- {gr} (1 row) I'm expecting '{r}' in the output as I thought this would use ARE mode by default. Thom