Commit 6dfacbf

committed

Add non-decimal integer support to type numeric.

This enhances the numeric type input function, adding support for hexadecimal, octal, and binary integers of any size, up to the limits of the numeric type. Since 6fcda9a, such non-decimal integers have been accepted by the parser as integer literals and passed through to numeric_in(). This commit gives numeric_in() the ability to handle them. While at it, simplify the handling of NaN and infinities, reducing the number of calls to pg_strncasecmp(), and arrange for pg_strncasecmp() to not be called at all for regular numbers. This gives a significant performance improvement for decimal inputs, more than offsetting the small performance hit of checking for non-decimal input. Discussion: https://postgr.es/m/CAEZATCV8XShnmT9HZy25C%2Bo78CVOFmUN5EM9FRAZ5xvYTggPMg%40mail.gmail.com

1 parent 62e1e28 commit 6dfacbfCopy full SHA for 6dfacbf

4 files changed

+405

-95

lines changed

src
- backend/utils/adt
  - numeric.c
- test/regress
  - expected
    - numeric.out
    - numerology.out
  - sql
    - numeric.sql

4 files changed

+405

-95

lines changed

Comments

0 (0)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Commit 6dfacbf

4 files changed

4 files changed

Search code, repositories, users, issues, pull requests...

File tree

4 files changed

4 files changed

0 commit comments