Tom Müller-Ackermann wrote:
> is it a known bug that the replace-function "does not exist" (even with
> typecasting the params to TEXT)? The function is in the Documentation,
> but does not work like documented, or am I missing something?
It exists starting in 7.3.
test=# select version();
version
-----------------------------------------------------------------
PostgreSQL 7.3.3 on i686-redhat-linux-gnu, compiled by GCC 2.96
(1 row)
test=# select replace('abcabc','ab','xy');
replace
---------
xycxyc
(1 row)
What version are you using? And if it is at least 7.3, show us the
command you're trying to execute.
Joe
