replace() and Regular Expressions
От
DEV
Тема
replace() and Regular Expressions
Дата
Msg-id
20051031181148.633B4DB573@svr1.postgresql.org
Список
Дерево обсуждения
replace() and Regular Expressions "DEV" <dev@umpa-us.com>
Re: replace() and Regular Expressions "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: replace() and Regular Expressions "DEV" <dev@umpa-us.com>
Is is possible to use replace along with regular expression to remove any and all punctuation from a field?
If so how?
I have tried: SELECT replace ('Brian\'s Co, INC.', 'Y*([.]',''),SUBSTRING('XY1234Z', 'Y*([0-9]{1,3})');
The second field substring works with out a problem the replace does not! How man I make that work?
В списке pgsql-general по дате отправления
