Re: Regex Query Index question
От
David Johnston
Тема
Re: Regex Query Index question
Дата
Msg-id
B1D22FDB-8AB1-4C74-AE54-1D91C91C669C@yahoo.com
Ответ на
Re: Regex Query Index question (David Johnston)
Список
Дерево обсуждения
Regex Query Index question Naoko Reeves <naokoreeves@gmail.com>
Re: Regex Query Index question Tom Lane <tgl@sss.pgh.pa.us>
Re: Regex Query Index question Naoko Reeves <naokoreeves@gmail.com>
Re: Regex Query Index question Tom Lane <tgl@sss.pgh.pa.us>
Re: Regex Query Index question David Johnston <polobo@yahoo.com>
Re: Regex Query Index question David Johnston <polobo@yahoo.com>
Re: Regex Query Index question David Johnston <polobo@yahoo.com>
>
> Not testing here but... and ignore whitespace
>
> '^( [ \[\( ]? \s* \d{3} \s* [ -\s\]\) ] \d{3} [ -\s ] \d{4} )$'
>
Some tweaks needed but seriously consider dropping RegEx and going the functional index route.
> '^( [ \[\( ]? \s* \d{3} \s* [ -\s\]\) ] \s* \d{3} \s* [ -\s ] \s* \d{4} )$'
Added some extra white-space checking but again not tested.
You can probably find better/more flexible expressions online.
David J.
В списке pgsql-general по дате отправления
