| From: | Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Subject: | FOR PORTION OF bounds not coerced in PREPARE |
| Date: | 2026-09-04 04:35:23 |
| Message-ID: | CA+renyW1uJp1dw=iK7MsWfbbZf-dKP_4JLoQ65wj=fry35FjCw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
Yours,
--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Resolve-untyped-parameters-in-FOR-PORTION-OF-FROM.patch | text/x-patch | 10.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nishant Sharma | 2026-09-04 04:36:44 | Re: [PATCH] Add support for SAOP in the optimizer for partial index paths |
| Previous Message | Ajin Cherian | 2026-09-04 04:33:45 | Re: PSQL schema "describe" \dn is not escaping quotes |