[FORMATTING] function name should not be changed in pgsql

[thilllon]

Hi, thanks for the great work.

$function$ should not be changed after formatting the code below:

Input data

Which SQL and options did you provide as input?

-- original code

CREATE OR REPLACE FUNCTION public.handle_new_user()
 RETURNS trigger
 LANGUAGE plpgsql
 SECURITY DEFINER
AS $function$
begin
  insert into public.profiles (id, full_name, avatar_url)
  values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url');
  return new;
end;
$function$
;

Expected Output

CREATE
    OR REPLACE FUNCTION public.handle_new_user() RETURNS trigger
    LANGUAGE plpgsql
    SECURITY DEFINER AS
$function$
begin
    insert into public.profiles (id, full_name, avatar_url)
    values (new.id,
            new.raw_user_meta_data ->> 'full_name',
            new.raw_user_meta_data ->> 'avatar_url');

    return new;
end;
$function$;

Actual Output

CREATE
OR REPLACE FUNCTION public.handle_new_user() RETURNS trigger LANGUAGE plpgsql SECURITY DEFINER AS $ function $ begin
-- Error occurs here `$ function $` 
insert into
  public.profiles (id, full_name, avatar_url)
values
  (
    new.id,
    new.raw_user_meta_data ->> 'full_name',
    new.raw_user_meta_data ->> 'avatar_url'
  );

return new;

end;

$ function $;

Usage

• How are you calling / using the library? vscode extension
• What SQL language(s) does this apply to? pgsql
• Which SQL Formatter version are you using? "sql-formatter": "^15.1.1"

[nene]

Thanks for reporting, but I'm unable to reproduce this issue.

Make sure you have selected PostgreSQL as the SQL dialect you want to format: https://github.com/sql-formatter-org/sql-formatter#parse-error-unexpected--at-line-

[thilllon]

My bad. It worked after setting this, "SQL-Formatter-VSCode.dialect": "postgresql" Thanks!