[postgis-users] Comparing phrases with typo error

b.j.kobben at utwente.nl b.j.kobben at utwente.nl
Tue Oct 15 02:22:52 PDT 2019


AGAIN: Use the INTERNET (w3schools.com/sql/ comes to mind)

Not for the first time, you are asking really basic SQL questions, ist is NOT good form to ask such trivial things which can be found in any SQL help page, book, tutorial, etc to a community of dedicated PostGIS users. They would be really willing to help you with questions actually about using PostGIS, but get extremely annoyed when you try to use them as quick help sheets.


yours
--
Barend Köbben


From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Shaozhong SHI <shishaozhong at gmail.com>
Reply to: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Date: Tuesday, 15 October 2019 at 10:23
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
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 true?

Regards,

Shao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191015/c792e261/attachment.html>


More information about the postgis-users mailing list