diff -r b92f5cceab78 -r c636ea2e8ee1 synapse/cmd.sh --- a/synapse/cmd.sh Fri Mar 04 10:54:52 2022 +0100 +++ b/synapse/cmd.sh Fri Mar 04 11:01:00 2022 +0100 @@ -56,13 +56,13 @@ if [ "$MODE" = "unts" ]; then echo "Creating unts() function; needs write access or you can simply copy the following code into psql." echo " " - SQL='CREATE OR REPLACE FUNCTION public.unts(bigint) + SQL="CREATE OR REPLACE FUNCTION public.unts(bigint) RETURNS timestamp with time zone LANGUAGE sql IMMUTABLE STRICT -AS $function$ - SELECT TIMESTAMP WITH TIME ZONE ''epoch'' + $1/1000 * INTERVAL ''1 second'' -$function$' +AS \$function$ + SELECT TIMESTAMP WITH TIME ZONE 'epoch' + \$1/1000 * INTERVAL '1 second' +\$function$" echo "${SQL}" echo " " $CMD "${SQL}"