clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601498 fiddles created (47966 in the last week).

select version();
version
PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit
 hidden batch(es)


select regexp_replace('1. xxxxxx1. xxxx1. ', '1. ', '')
regexp_replace
xxxxxx1. xxxx1.
 hidden batch(es)