Fails at formatting functions. about coc-sql HOT 6 CLOSED

  "sql.formatOptions": {
    "language": "postgresql"
  },

create or replace function hot_rank(
  score numeric,
  published timestamp without time zone)
returns integer as $$
begin
  -- hours_diff:=EXTRACT(EPOCH FROM (timezone('utc',now()) - published))/3600
  return floor(10000*log(greatest(1,score+3)) / power(((EXTRACT(EPOCH FROM (timezone('utc',now()) - published))/3600) + 2), 1.8))::integer;
end; $$
LANGUAGE plpgsql
IMMUTABLE;

create
or replace function hot_rank(score numeric, published timestamp without time zone) returns integer as $ $ begin -- hours_diff:=EXTRACT(EPOCH FROM (timezone('utc',now()) - published))/3600
return floor(
  10000 * log(greatest(1, score + 3)) / power(
    (
      (
        EXTRACT(
          EPOCH
          FROM
            (timezone('utc', now()) - published)
        ) / 3600
      ) + 2
    ),
    1.8
  )
):: integer;
end;
$ $ LANGUAGE plpgsql IMMUTABLE;