4 ms·

I am completely new to PL/pgSQL, so forgive me for the BASIC question, but (out of curiosity) for string manipulation is PL/pgSQL too slow compared to modern LU

by jfbaro 5y ago

I am completely new to PL/pgSQL, so forgive me for the BASIC question, but (out of curiosity) for string manipulation is PL/pgSQL too slow compared to modern LUA/Python? The function that I have in mind will get a TEXT and return another TEXT with the PHONETIC representation of this TEXT.

wswope 5y ago
The sort of algorithm you have in mind is usually called a soundex (“sound-index”). Fairly confident order of performance would be PL/pgSQL > Lua > Python.
- jfbaro 5y ago
  Thank you very much! I really appreciated it.