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,
David
