Horton
Menu

Re: pg_catalog.pg_get_viewdef pretty-print removes important parentheses

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Duncan Sands <duncan.sands@deepbluecap.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2022-12-01T15:37:05Z
Lists: pgsql-bugs 
Duncan Sands <duncan.sands@deepbluecap.com> writes:
> When pg_catalog.pg_get_viewdef is called with pretty-print enabled, it removes 
> parentheses around (DATE + INTERVAL) in the construct "(DATE + INTERVAL) AT TIME 
> ZONE TZ", outputting SQL that fails to parse.

So it does :-(.  Will fix, thanks for the report!

			regards, tom lane

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix under-parenthesized display of AT TIME ZONE constructs.