ERROR: function regexp_like(character varying, unknown) does not exist

Question

I have this SQL query that I'm writing using Postgresql.

select * from cdr_data 
  where REGEXP_LIKE(identifiant,'^73')
    and REGEXP_REPLACE(callednumber,'^256','') ~ '^73'

It gives me following error:

[Err] ERROR:  function regexp_like(character varying, unknown) does not exist
LINE 2: and  regexp_like(identifiant,'^73')

I have tried replace with REGEXP_LIKE with LIKE and REGEXP_MATCHES but they don't work.

What could be the problem?

Answer 1

The PostgreSQL equivalent of regexp_like(identifiant,'^73') is identifiant ~ '^73'