På tirsdag 23. november 2021 kl. 12:25:29, skrev Shaozhong SHI < shishaozh...@gmail.com <mailto:shishaozh...@gmail.com>>:
It only matches First Street from 'My First Street'. I was trying to make it to match words starting capital letter only. You'll want to include unicode-characters, which [A-Z] approach doesn't handle well. How about: select regexp_matches('Åge is a Man', E'[[:upper:]]\\w+', 'g'); -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>