Hi, Similarity search for text is a task of pg_trgm, not PostGIS. Here's doc with how you do it: https://www.postgresql.org/docs/12/pgtrgm.html
On Mon, Oct 14, 2019 at 10:23 PM Shaozhong SHI <shishaozh...@gmail.com> wrote: > This is an interesting problem. > > SELECT 'city centre' ~* 'city centRe '; > > Between city and centRe, there are 2 spaces. At the end, there is one > space. > > How to make this true? > > Regards, > > Shao > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users -- Darafei Praliaskouski Support me: http://patreon.com/komzpa
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
