Horton

Allow underscores in integer and numeric constants.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: faff8f8e47f18c7d589453e2e0d841d2bd96c1ac
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2023-02-04T09:48:51Z
Releases: 16.0 
Allow underscores in integer and numeric constants.

This allows underscores to be used in integer and numeric literals,
and their corresponding type input functions, for visual grouping.
For example:

    1_500_000_000
    3.14159_26535_89793
    0xffff_ffff
    0b_1001_0001

A single underscore is allowed between any 2 digits, or immediately
after the base prefix indicator of non-decimal integers, per SQL:202x
draft.

Peter Eisentraut and Dean Rasheed

Discussion: https://postgr.es/m/84aae844-dc55-a4be-86d9-4f0fa405cc97%40enterprisedb.com

Files

PathChange+/−
doc/src/sgml/syntax.sgml modified +23 −13
src/backend/catalog/sql_features.txt modified +1 −0
src/backend/parser/parse_node.c modified +4 −39
src/backend/parser/scan.l modified +14 −13
src/backend/utils/adt/numeric.c modified +83 −23
src/backend/utils/adt/numutils.c modified +213 −60
src/fe_utils/psqlscan.l modified +8 −8
src/interfaces/ecpg/preproc/pgc.l modified +8 −8
src/pl/plpgsql/src/expected/plpgsql_trap.out modified +1 −1
src/pl/plpgsql/src/sql/plpgsql_trap.sql modified +1 −1
src/test/regress/expected/int2.out modified +44 −0
src/test/regress/expected/int4.out modified +44 −0
src/test/regress/expected/int8.out modified +44 −0
src/test/regress/expected/numeric.out modified +58 −4
src/test/regress/expected/numerology.out modified +88 −4
src/test/regress/expected/partition_prune.out modified +3 −3
src/test/regress/sql/int2.sql modified +14 −0
src/test/regress/sql/int4.sql modified +14 −0
src/test/regress/sql/int8.sql modified +14 −0
src/test/regress/sql/numeric.sql modified +19 −3
src/test/regress/sql/numerology.sql modified +23 −1
src/test/regress/sql/partition_prune.sql modified +3 −3

Documentation touched

Discussion