Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3

From:	Nitin Motiani <nitinmotiani(at)google(dot)com>
To:	assam258(at)gmail(dot)com
Cc:	alpkeles99(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject:	Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3
Date:	2026-10-25 12:03:00
Message-ID:	CAH5HC96Bon8tvbT90jJFxzQ9zKkzHw-X1LiOXJj=Y=wbXgPgNw@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2026-10-16 15:59:56 from PG Bug reporting form <noreply(at)postgresql(dot)org>  2026-10-19 11:29:58 from Nitin Motiani <nitinmotiani(at)google(dot)com> 📎   2026-10-19 14:35:03 from Henson Choi <assam258(at)gmail(dot)com>    2026-10-22 13:00:04 from Nitin Motiani <nitinmotiani(at)google(dot)com>     2026-10-25 12:03:00 from Nitin Motiani <nitinmotiani(at)google(dot)com> 📎      2026-10-26 07:00:14 from Henson Choi <assam258(at)gmail(dot)com>
Lists:	pgsql-bugs

Attachment	Content-Type	Size
v2-0001-Fix-deparsing-of-unary-operators-applied-to-const.patch	application/x-patch	6.1 KB

In response to

• Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 at 2026-10-22 13:00:04 from Nitin Motiani

Responses

• Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 at 2026-10-26 07:00:14 from Henson Choi

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Ayush Tiwari	2026-10-25 14:03:19	Re: BUG #19783: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out
Previous Message	Nitin Motiani	2026-10-25 11:35:39	Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date