RES: [GENERAL] Using regexp_replace to remove small words

2010-12-13 Thread Henrique de Lima Trindade
: 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 de Lima Trindade Cc: pgsql-general@postgresql.org Assunto: Re: [GENERAL

[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