title: PostgreSQL remove char from column that endswith
body: <p>Need to remove the values in a column that ends with those char : "*8"</p>
  
  <p>I've found them with:</p>
  
  <pre><code>    SELECT 
          "PIPPO"  
      FROM 
          "PLUTO"
      WHERE
      "PIPPO" LIKE '%*8'
  </code></pre>
  
  <p>is there a simple way to <strong>remove</strong> those ending characters with a query?</p>