Re: Match 2 words and more

[Guyren Howe]

On Nov 27, 2021, at 16:27 , Shaozhong SHI <shishaozh...@gmail.com> wrote:
> 
> select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$’;

The simplest thing that does what you says is I think:

select name FROM a_table where "STREET_NAME" ~ 
‘^([[:alpha:]]+\s)+[[:alpha:]]+$’;