Wrong formatted PostgreSQL

[ansidev]

Input:

CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE OR REPLACE FUNCTION generate_ulid() RETURNS uuid
    AS $$
        SELECT (lpad(to_hex(floor(extract(epoch FROM clock_timestamp()) * 1000)::bigint), 12, '0') || encode(gen_random_bytes(10), 'hex'))::uuid;
    $$ LANGUAGE SQL;

Output:

CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE
OR REPLACE FUNCTION generate_ulid() RETURNS uuid AS $ $
SELECT
  (
    lpad(
      to_hex(
        floor(
          extract(
            epoch
            FROM
              clock_timestamp()
          ) * 1000
        ) :: bigint
      ),
      12,
      '0'
    ) || encode(gen_random_bytes(10), 'hex')
  ) :: uuid;
$ $ LANGUAGE SQL;

[nrempel]

Thanks for the report! Right now this CLI is a front end for https://github.com/shssoichiro/sqlformat-rs. Can you open an issue there?

[ansidev]

@nrempel shssoichiro/sqlformat-rs#20