pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedExtra brackets when viewing SQL
3+ messages / 3 participants
[nested] [flat]
* Extra brackets when viewing SQL
@ 2020-12-10 14:48 Joe Tailleur <joe.tailleur@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Joe Tailleur @ 2020-12-10 14:48 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Extra brackets when viewing SQL
@ 2020-12-10 14:52 Blum, Kimber <kimber7@illinois.edu>
parent: Joe Tailleur <joe.tailleur@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Blum, Kimber @ 2020-12-10 14:52 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
I agree! That is a pain.
From: Joe Tailleur <joe.tailleur@gmail.com>
Sent: Thursday, December 10, 2020 8:49 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Extra brackets when viewing SQL
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Extra brackets when viewing SQL
@ 2020-12-10 15:10 Ron <ronljohnsonjr@gmail.com>
parent: Joe Tailleur <joe.tailleur@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ron @ 2020-12-10 15:10 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 12/10/20 8:48 AM, Joe Tailleur wrote:
> Hi all,
>
> In version 4.27 when I viewed my SQL (sql tab when highlighting an item).
Of pgadmin? You need the pgadmin-support@postgresql.org list, not the
pgsql-admin@lists.postgresql.org list.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-12-10 15:10 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-10 14:48 Extra brackets when viewing SQL Joe Tailleur <joe.tailleur@gmail.com>
2020-12-10 14:52 ` Blum, Kimber <kimber7@illinois.edu>
2020-12-10 15:10 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox