[postgis-users] function soundex(text) does not exist

[Regina Obe]

Did you install extension fuzzystrmatch?

 

CREATE EXTENSION fuzzystrmatch;

 

Soundex is not a built-in function in PostgreSQL – it is packaged in the fuzzystrmatch extension which is part of contrib extensions.

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Shaozhong SHI
Sent: Tuesday, January 5, 2021 4:49 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [postgis-users] function soundex(text) does not exist

 

We tried to use soundex in where clause, but kept getting the following error.

 

ERROR: function soundex(text) does not exist LINE 1: ...(pao_start_number,pao_end_number,1) as index) or (soundex(fu... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. SQL state: 42883 Character: 495  

 

Can anyone enlighten me?

 

Regards,

 

David

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