On Sun, 30 Jun 2024 at 23:42, fujii.y...@df.mitsubishielectric.co.jp <fujii.y...@df.mitsubishielectric.co.jp> wrote: > Instead, I can make PARTIAL_AGGREGATE an unreserved word by placing it after > the FILTER clause, like avg(c1) FILTER (WHERE c2 > 0) PARTIAL_AGGREGATE, and > by marking it as an ASLABEL word like FILTER. > I attached the patch of the method. > If there are no objections, I would like to proceed with the method described > above. > I'd appreciate it if anyone comment the method.
I like this approach of using PARTIAL_AGGREGATE in the same place as the FILTER clause.