Re: Row pattern recognition

From: Henson Choi <assam258(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: vik(at)postgresfriends(dot)org, er(at)xs4all(dot)nl, jacob(dot)champion(at)enterprisedb(dot)com, david(dot)g(dot)johnston(at)gmail(dot)com, peter(at)eisentraut(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Row pattern recognition
Date: 2026-02-24 04:38:32
Message-ID: CAAAe_zAc4CQDMP5WVuNZq5q6A_CymN5xwrva38df3okrtYdYsw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tatsuo,

> BTW, in create_windowagg_plan (createplan.c),
> around:
> /* Build RPR pattern and filter defineClause */
>
> collectPatternVariables, filterDefineClause and buildRPRPattern are
> called in a block without any if or any other conditional
> statements. This is an unusual codiing style in PostgreSQL. I suggest
> to fix this. Attached is a proposed patch for this.

Good catch, thank you! I've renumbered your patch as nocfbot-0007
and extended the same cleanup to rpr.c and parse_rpr.c as
nocfbot-0008.

nocfbot-0007: Refactor create_windowagg_plan to remove bare
variable-scoping block (your patch, renumbered)

nocfbot-0008: Remove bare variable-scoping blocks in RPR code

Applies the same cleanup to rpr.c and parse_rpr.c, with minor
pgindent formatting fixes.

I'll keep this coding style point in mind for future code as well.

Best regards,
Henson

Attachment Content-Type Size
nocfbot-0007-Refactor-create_windowagg_plan-to-remove-bare-variab.patch application/octet-stream 3.3 KB
nocfbot-0008-Remove-bare-variable-scoping-blocks-in-RPR-code.patch application/octet-stream 7.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Manni Wood 2026-02-24 04:44:44 Re: Speed up COPY FROM text/CSV parsing using SIMD
Previous Message Bryan Green 2026-02-24 04:31:55 Re: [PATCH] Add Windows support for backtrace_functions (MSVC only)