Question : I want to be able to search unaccented phrases in an inflected (Polish) language in Postgres. Say, if […]
PostgreSQL translate special characters?
Question : Description: PostgreSQL 9.3 String: ‘ì ằ ú ề’ Desired Result: ‘i a u e’ My code: select translate […]
How to query efficiently from Postgres to select special words?
Question : Let’s say that I have a table called words with very many records. Columns are id and name. […]
“Function unaccent(text) does not exist” in update trigger
Question : I’ve created a trigger for table x1 to update a column y with the expression to_tsvector(unaccent(x1.col1 || ‘ […]
text search dictionary “unaccent” does not exist’ entries in postgres log, supposedly during automatic analyze
Question : I have many such entries in the postgresql main log, ever since upgrading to Postgres 10: 2018-03-28 08:51:00.281 […]