Re: Match 2 words and more

[Rob Sargent]

> On Nov 27, 2021, at 5:27 PM, Shaozhong SHI <shishaozh...@gmail.com> wrote:
> 
> 
> this is supposed to find those to have 2 words and more.
> 
> select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$';
> 
> But, it finds only one word as well.
> 
> It appears that regex is not robust.
> 
> Can anyone shed light on this?
> 
> Regards,
> 
Show the results of the query. Describe how those results differ from what you 
desire or from what you expect. 


> David