M4X <77...@gmx.com> writes: > It seem that is possible to make a search that is case and accent > insensitive. > |I've dig https://www.postgresql.org/docs/current/textsearch-intro.html > and other resources,| > |but I didn't find yet an example that demonstrate it.
The text search functionality is already case-insensitive, but not accent-insensitive (at least in the common built-in configurations). To make it accent-insensitive, you can set up a custom configuration using the "unaccent" module. See https://www.postgresql.org/docs/current/unaccent.html regards, tom lane
