Match 2 words and more
| От | Shaozhong SHI |
|---|---|
| Тема | Match 2 words and more |
| Дата | |
| Msg-id | CA+i5Jwbzej+34xLZvyVj1rM=SrXO1f+P4scaJUA2Y4xQfAJ0=A@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Match 2 words and more
Re: Match 2 words and more Re: Match 2 words and more Re: Match 2 words and more Re: Match 2 words and more Re: Match 2 words and more Re: Match 2 words and more |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: