Prevent numeric literals from having non-numeric trailing characters (Peter Eisentraut)

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Prevent numeric literals from having non-numeric trailing characters (Peter Eisentraut)
Date: 2025-06-20 13:29:40
Message-ID: CAA5-nLDcfXZiXPNUW0eNAr3odK+aY-rCZ3FJ_8UCYWmc8HwkBQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Regarding the changes made in version 15 for the traitment of the non-numeric
trailing characters, why does parsing continue to be permissive with
parentheses (no need to add a space)? Are we still in standard SQL?

Regards

Fabrice

SELECT (123)order by 1;
+----------+
| ?column? |
+----------+
| 123 |
+----------+
(1 row)

postgres [2043238]=# SELECT (123)abc;
+-----+
| abc |
+-----+
| 123 |
+-----+
(1 row)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2025-06-20 13:44:08 Re: [PATCH] pg_bsd_indent: improve formatting of multiline comments
Previous Message Peter Eisentraut 2025-06-20 13:21:40 Re: Huge commitfest app update upcoming: Tags, Draft CF, Help page, and automated commitfest creat/open/close