[GENERAL] Using regexp_replace to remove small words

2010-12-10 Thread Henrique de Lima Trindade
Hi, I'm trying to find a regular expression that removes all small (length < N) words from a string. But, until now I've not been successful. For example: If I pass 'George W Bush' as parameter, I want regexp_replace to return 'George Bush'. Other examples are: select regexp_rep

RES: [GENERAL] Using regexp_replace to remove small words

2010-12-13 Thread Henrique de Lima Trindade
^ ** Error ** ERRO: erro de sintaxe em ou próximo a "\" SQL state: 42601 Character: 138 Thanks again! -Mensagem original- De: Peter Eisentraut [mailto:pete...@gmx.net] Enviada em: sexta-feira, 10 de dezembro de 2010 20:59 Para: Henrique d