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_timeoutTO _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.eisentraut@2ndquadrant.com]
Gesendet: Dienstag, 24. September 2019 09:05
An: Witczak, Jakob; jonathan.katz@excoventures.com
Cc: pgsql-sql@postgresql.org
Betreff: Re: AW: German "umlaut insensitive" query

On 2019-09-23 07:57, Jakob.Witczak@dlr.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