Fails at formatting functions.

[dessalines]

This seems to do okay formatting with everything but functions. With functions it even adds syntax errors:

  create function site_aggregates_user() returns trigger language plpgsql as $ $ begin IF (TG_OP = 'INSERT') THEN
update
  site_aggregates
set
  users = users + 1;

[fannheyward]

sql-formatter-org/sql-formatter#116

[dessalines]

Ah dang.

[fannheyward]

The latest release of cic-sql has upgrade sql-formatter to 4.0 with postsql dollar-quoted support, please give it a try.

[dessalines]

I just tried it, it still does the same thing, creates a space in between dollar quotes, and has some messed up newlines too.

before

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;

after

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;

[fannheyward]

You need to set sql.formatOptions in coc-settings.json

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

[dessalines]

Ah yep that did it, thank you!