I have a table in a PostgreSQL DB and I am trying to extract a substring with a certain pattern from a string as a result of extracting specific data from a jsonb column. The string of interest is extracted by using the following command (I include all the details in case of some side-effect that I didn’t notice):