Thread: FUNCTION REPLACE() "does not exist" ?

Hi,

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?

What can I use instead of REPLACE in a plpgsql-function?

Thanks for any Help!

tom-

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