[postgis-users] Comparing phrases with typo error

[Darafei "Komяpa" Praliaskouski]

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 <shishaozhong at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191015/156433a4/attachment.html>