Re: pg_stat_statements: Fix normalization of + signs for FETCH and MOVE

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>
Subject: Re: pg_stat_statements: Fix normalization of + signs for FETCH and MOVE
Date: 2026-06-01 06:06:37
Message-ID: ah0hbY0v8zwJZU0R@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 01, 2026 at 01:33:40PM +0800, Chao Li wrote:
> As shown above, the "+" sign is replaced separately from the
> integer. However, a "-" sign is handled correctly:
> ```
> We just need to handle "+" in the same way. See the attached patch for details.

This is not directly related to FETCH and MOVE. For example:
=# select +1;
?column?
----------
1
(1 row)
=# select query from pg_stat_statements where query ~ 'select';
query
------------
select +$1
(1 row)

I don't recall somebody complaining about that..
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message liu zhilong 2026-06-01 06:10:51 [PATCH] doc: explain database-wide impact of old xmin on VACUUM
Previous Message Kyotaro Horiguchi 2026-06-01 05:49:22 Re: Add wait events for server logging destination writes