> On Nov 27, 2021, at 5:27 PM, Shaozhong SHI <shishaozhong@xxxxxxxxx> 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
