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-boun...@lists.osgeo.org> on behalf of Shaozhong SHI <shishaozh...@gmail.com> Reply to: PostGIS Users Discussion <postgis-users@lists.osgeo.org> Date: Tuesday, 15 October 2019 at 10:23 To: PostGIS Users Discussion <postgis-users@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
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
