[postgis-users] Comparing phrases with typo error

[schild]

--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'));

Cheers,
Andreas