Table-wide Replace Limit

Hi -
I am working on using a table-wide Replace action to replace anywhere that has 2019 with 2020

The data in the column is >300 characters long, I’ve noticed that it will not let me say “Where it’s” entire cell or part of a longer text

Can I assume there is a limit in place for that type of action?


Here is a snippet of the data
SELECT count(DISTINCT AS "1/1/2019" FROM customerview_totaltrunk_temp WHERE ((customerview_totaltrunk_temp.ordercompleted >= '2018-01-01 00:00:00'::timestamp without time zone) AND (customerview_totaltrunk_temp.ordercompleted < '2019-02-01 00:00:00'::timestamp without time zone));

It assumes that 2019 is a number, not text. As with numbers partial replacement is not possible, it offers to replace entire number. There is no limit on text length.

I would suggest using the replace() function if you need to replace a number in a text.