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