FOR PORTION OF bounds not coerced in PREPARE - Mailing list pgsql-hackers

From Paul A Jungwirth
Subject FOR PORTION OF bounds not coerced in PREPARE
Date
Msg-id CA+renyW1uJp1dw=iK7MsWfbbZf-dKP_4JLoQ65wj=fry35FjCw@mail.gmail.com
Whole thread
List pgsql-hackers
Hi Hackers,

Here is a fix for findings D2 & D12 from [0].

The issue is FOR PORTION OF bounds are not coerced, so PREPARE
requires casting them and a NULL deparses as ::unknown not
::date/::timestamp/etc. We actually do coerce these bounds, since we
have to build a range constructor, but we don't put those into the
ForPortionOfExpr struct. This commit fixes that.

[0] https://www.postgresql.org/message-id/CA%2BrenyV6QLOJYmLo3gbsg1Y%2BCrho8NqME1jJXgPbO_NgxfBaKQ%40mail.gmail.com

Yours,

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com

Attachment

pgsql-hackers by date:

Previous
From: Ajin Cherian
Date:
Subject: Re: PSQL schema "describe" \dn is not escaping quotes
Next
From: Nishant Sharma
Date:
Subject: Re: [PATCH] Add support for SAOP in the optimizer for partial index paths