Re: [SQL] Is there an easy way to normalize-space with given string functions

2004-04-23 Thread Janning Vygen
Am Freitag, 23. April 2004 04:34 schrieb Tom Lane: > Janning Vygen <[EMAIL PROTECTED]> writes: > > i searched the function list and tried to combine to or more > > functions, but i miss a replace function which uses regular > > expressions. > > There isn't one in the SQL standard. Most people who

Re: [SQL] Is there an easy way to normalize-space with given string functions

2004-04-22 Thread Tom Lane
Janning Vygen <[EMAIL PROTECTED]> writes: > i searched the function list and tried to combine to or more > functions, but i miss a replace function which uses regular > expressions. There isn't one in the SQL standard. Most people who need one write a one-liner function in plperl or pltcl. (Mind

[SQL] Is there an easy way to normalize-space with given string functions

2004-04-22 Thread Janning Vygen
Hi, i am looking for something like $ SELECT btrim(replace(' too many spaces! ', '\s+',' '), ''); too many spaces i searched the function list and tried to combine to or more functions, but i miss a replace function which uses regular expressions. Do i have to write my own function or did