[#48288] - Postgres soundex
- Closed
- 23 Aug 2026
- Medium
- Build: 5.4-dev
- # 48288
I was trying to install joomla with postgres and was getting an error
* ERROR: unterminated dollar-quoted string at or near "$$
DECLARE
soundex text = ''"
LINE 13: AS $$
^ */
The fact I got an error is probabaly my fault and not directly the topic of this bug report
Looking at that code its from https://wiki.postgresql.org/wiki/Soundex BUT do we need it now? If I understood it correctly thats now been usurped by fuzzystrmatch
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
bug
|
||
The soundex function is created here for PostgreSQL so we have a function with that name available in both kinds of databases (in MySQL and MariaDB it is built in):
https://github.com/joomla/joomla-cms/blob/5.4-dev/installation/sql/postgresql/extensions.sql#L1166-L1226
It is used by com_finderhere:
https://github.com/joomla/joomla-cms/blob/5.4-dev/administrator/components/com_finder/src/Indexer/Indexer.php#L523-L536
The soundex function is created here for PostgreSQL so we have a function with that name available in both kinds of databases (in MySQL and MariaDB it is built in):
https://github.com/joomla/joomla-cms/blob/5.4-dev/installation/sql/postgresql/extensions.sql#L1166-L1226
It is used by com_finder here:
https://github.com/joomla/joomla-cms/blob/5.4-dev/administrator/components/com_finder/src/Indexer/Indexer.php#L523-L536
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2026-08-23 12:26:42 |
| Closed_By | ⇒ | brianteeman |
ok thanks for explaining
The soundex function is created here for PostgreSQL so we have a function with that name available in both kinds of databases:
https://github.com/joomla/joomla-cms/blob/5.4-dev/installation/sql/postgresql/extensions.sql#L1166-L1226
It is used by com_finderhere:
https://github.com/joomla/joomla-cms/blob/5.4-dev/administrator/components/com_finder/src/Indexer/Indexer.php#L523-L536
And here:
https://github.com/joomla/joomla-cms/blob/5.4-dev/administrator/components/com_finder/src/Indexer/Query.php#L1317-L1322