Postgres Pro
Downloads
Home   >   mailing lists

Re: Regex for Word space Word space Word .... - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: Regex for Word space Word space Word ....
Date
Msg-id VisenaEmail.66.722aa014626d9b9e.17d4cc64a8a@tc7-visena
Whole thread Raw
In response to Re: Regex for Word space Word space Word ....  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view
På tirsdag 23. november 2021 kl. 12:25:29, skrev Shaozhong SHI <shishaozhong@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
 
Attachment

pgsql-general by date:

Previous
From: Saurabh Agrawal
Date:
Subject: Re: Regex for Word space Word space Word ....
Next
From: Matthias Apitz
Date:
Subject: Re: SELECT fails to present result rows depending on the columns to show