--- 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}"