title: Like operator condition in postgresql data issue
body: <p>I have below data in the table </p>
  
  <pre><code>HJ-DEF-ABCF010-ABC18-09-17-D
  GHJ-ABC-ABFV006-ABC18-09-18-R
  OH-DEF-ABFCRT2037-ABC17-01-18-R
  </code></pre>
  
  <p>I want to populate the value in another column like </p>
  
  <pre><code>HJ-DEF-ABCF010-ABC18-09-17-D             BET
  GHJ-ABC-ABFV006-ABD18-09-18-R            BET
  OH-DEF-ABFCRT2037-ABCD17-01-18-R          BET
  </code></pre>
  
  <p>As the mapping for </p>
  
  <pre><code>ABC18 is BET   
  ABD18 is BET
  ABCD17 is BET
  </code></pre>
  
  <p>I was using the below sql query for that </p>
  
  <pre><code>select col1,case 
  when col1 like '%-ABC[1-2][0-9]-%' then BET 
  when col1 like '%-ABD[1-2][0-9]-%' then BET 
  when col1 like '%-ABCD[1-2][0-9]-%' then BET
  else - end form table
  </code></pre>
  
  <p>which is working fine in SQl sever but in Pogresql we can't use [1-2] to find out the expected digit in the position. Any suggestion or idea how to achieve in Posgresql.</p>