Extra brackets when viewing SQL

From: Joe Tailleur <joe(dot)tailleur(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Extra brackets when viewing SQL
Date: 2020-12-10 14:48:40
Message-ID: CAPZdUVph0JmBLssbaxAVNDLSt8TxJj7d2COsTG2_pRxLPFSX9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

In version 4.27 when I viewed my SQL (sql tab when highlighting an item).

For example:
CREATE OR REPLACE VIEW asap.view_assignment
AS
SELECT pa.assign_id,
pa.proj_id,
pa.date_assigned,
pa.time_assigned,
au.user_name AS assigned_to,
pa.assigned_level,
pa.note,
eb.user_name AS assigned_by
FROM proj_assign pa
JOIN asap_users au ON au.user_uid = pa.assigned_to_user
LEFT JOIN asap_users eb ON eb.user_uid = pa.assigned_by_user;

In version 4.28 (and 4.29)
CREATE OR REPLACE VIEW asap.view_assignment
AS
SELECT pa.assign_id,
pa.proj_id,
pa.date_assigned,
pa.time_assigned,
au.user_name AS assigned_to,
pa.assigned_level,
pa.note,
eb.user_name AS assigned_by
FROM ((proj_assign pa
JOIN asap_users au ON ((au.user_uid = pa.assigned_to_user)))
LEFT JOIN asap_users eb ON ((eb.user_uid = pa.assigned_by_user)));

I really don't like the extra brackets that are being placed around the
FROM and JOINs, and they show up as well in CASE statements within SELECT
and other sections as well. Can I somehow disable this? It's a real pain
in the butt.

Joe.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Blum, Kimber 2020-12-10 14:52:10 RE: Extra brackets when viewing SQL
Previous Message Ron 2020-12-10 07:21:58 Re: Version expire date