You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If we put the following procedure into the pgFormatter, we will see the indentation is not right: The end ")" comes to the very beginning of the line. Also the keyword "with" is not uppercased nor is highlighted.
CREATE OR REPLACE PROCEDURE test ()
LANGUAGE plpgsql
AS $$
BEGIN
CREATE temp TABLE test AS
with reg_data AS (
SELECT
buyer
FROM
reg
WHERE
status = 'Enabled'
)
SELECT
buyer
FROM
reg_data;
END;
$$
The text was updated successfully, but these errors were encountered:
If we put the following procedure into the pgFormatter, we will see the indentation is not right: The end ")" comes to the very beginning of the line. Also the keyword "with" is not uppercased nor is highlighted.
CREATE OR REPLACE PROCEDURE test ()
LANGUAGE plpgsql
AS $$
BEGIN
CREATE temp TABLE test AS
with reg_data AS (
SELECT
buyer
FROM
reg
WHERE
status = 'Enabled'
)
SELECT
buyer
FROM
reg_data;
END;
$$
The text was updated successfully, but these errors were encountered: