Postgresql – How to use posix regexp operator for substring match
I'm trying to move from ILIKE to Postgres ~* operator. Tables have bpchar columns (cannot changed). Tried in Postgres 12 create temp table test ( tasudok char(25), nimetus char (100) ) on commit drop ; insert into test values ('123','Teie…