--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?
SELECT 'city centre' not similar to 'city centRe ';
OR
SELECT 'city centre' ~* trim(regexp_replace('city centRe ', '\s+', ' ', 'g'));
Cheer
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
wrote:
> This is an interesting problem.
>
> SELECT 'city centre' ~* 'city centRe ';
>
> Between city a
: PostGIS Users Discussion
Subject: [postgis-users] Comparing phrases with typo error
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 t
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
h
