I use [email protected] and I would like to have wildcard characters and the unaccent function of the PostgreSQL.
My pl/pgsql query has something like
WHERE unaccent(p.name) ILIKE (''%'' || unaccent($1) || ''%'')'
I want to make it into a pg-promise query like
uniqueQuery('select id, name from place WHERE unaccent(name) ILIKE \'% unaccent($1) #%\' ', [name])
Without the unaccent it works fine. When I add the unaccent , I get a synta error : error: syntax error at or near "ονομα μερους" (ονομα μερους is an the string I am searching for).
How can I combine the wildcards with the unaccent ?
Thanks