AW: AW: German "umlaut insensitive" query

Super, thank you so much for the tip.

I still have a little problem where I don't get far ;-)

I constantly get an error message when I give the SET a value.
Siehe unten.

ERROR: ERROR: invalid value for parameter "idle_in_transaction_session_timeout": "_timeout" CONTEXT: SQL statement "SET idle_in_transaction_session_timeout TO _timeout" PL/pgSQL function set_transfer(integer,character varying,character varying) Line 4 at SET SQL state: 22023SELECT * FROM

Call function:
set_transfer(87,'users','5000');

Function:

CREATE OR REPLACE FUNCTION public.set_transfer(_id integer, _tablename character varying, _timeout character varying)
RETURNS SETOF users
LANGUAGE 'plpgsql'AS $BODY$
BEGIN
SET idle_in_transaction_session_timeout TO _timeout;
......
END

I've tried almost everything. :-(

Best Regards
Jakob

-----Ursprüngliche Nachricht-----
Von: Peter Eisentraut [mailto:peter(dot)eisentraut(at)2ndquadrant(dot)com]
Gesendet: Dienstag, 24. September 2019 09:05
An: Witczak, Jakob; jonathan(dot)katz(at)excoventures(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Betreff: Re: AW: German "umlaut insensitive" query

On 2019-09-23 07:57, Jakob(dot)Witczak(at)dlr(dot)de wrote:
> Thanks for the quick answer. I am looking forward to the new PostgresSQL
> version. Thanks

In the meantime, the unaccent contrib module can also help.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services