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 you, I don't know why we don't offer a built-in one --- the needed regex engine is in there anyway. I guess no one has gotten around to getting agreement on a syntax.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings