using replace function

[Antonio Silva]

Hello list

I want to replace a string (not a substring) in a field but making sure
that the string in the full field.

In the example below since 'blue' is not the full text in 'blue shark'
there should not have a replacement.

How to say "replace only with 'blue' if it is the full string in the field".

With REPLACE I get:

SELECT REPLACE('blue shark','blue','blue fish');
     replace
-----------------
 blue fish shark
(1 row)

but I would like to get:

SELECT REPLACE('blue shark','blue','blue fish');
  replace
------------
 blue shark
(1 row)

Thanks a lot

Antonio Olinto