title: Postgres SQL regexp_replace replace all number
body: <p>I need some help with the next. I have a field text in SQL, this record a list of times sepparates with '|'. For example</p>
  <p>'14613|15474|3832|148|5236|5348|1055|524' Each value is a time in milliseconds. This field could any length, for example is perfect correct '3215|2654' or '4565' (only 1 value). I need get this field and replace all number with -1000 value.</p>
  <p>So '14613|15474|3832|148|5236|5348|1055|524' will be '-1000|-1000|-1000|-1000|-1000|-1000|-1000|-1000'</p>
  <p>Or '3215|2654' =&gt; '-1000|-1000' Or '4565' =&gt; '-1000'.</p>
  <p>I try use regexp_replace(times_field,'[[:digit:]]','-1000','g') but it replace each digit, not the complete number, so in this example:</p>
  <p>'3215|2654' than must be '-1000|-1000', i get:</p>
  <p>'-1000-1000-1000-1000|-1000-1000-1000-1000', I try with other combinations and more options of regexp but i'm done.</p>
  <p>Please need your help, thanks!!!.</p>