CREATE OR REPLACE PROCEDURE test()

AS $$

BEGIN

  SELECT 1 a;

END;

$$

LANGUAGE plpgsql

;

/

 

I got following error:

>[Error] Script lines: 1-4 --------------------------

Unterminated dollar quote started at position 38 in SQL CREATE OR REPLACE PROCEDURE test()

AS $$

BEGIN

  SELECT 1 a. Expected terminating $$

 

 

[Executed: 11/8/2021 11:15:53 AM] [Execution: 0ms]

 

 

0 record(s) affected

 

[Executed: 11/8/2021 11:15:53 AM] [Execution: 27ms]

 

>[Error] Script lines: 6-8 --------------------------

Unterminated dollar quote started at position 0 in SQL $$

LANGUAGE plpgsql

. Expected terminating $$

 

 

[Executed: 11/8/2021 11:15:53 AM] [Execution: 0ms]