Which part of PostgreSQL code is handling type definition?

Question

In PostgreSQL when I call NUMERIC(10,2) to define a variable type. Which part of the PostgreSQL C code is handling it?

I am interested in knowing where the precision and scale are handled.

Craig Ringer · Accepted Answer · 2017-07-03 05:26:22Z

2

Lots of parts.

The lexer and parser transforms it into a type name and type modifier.

The system catalogs and syscache look up numeric to find the matching type oid.

The numeric.c code handles the actual type input/output and operators, and interprets the type modifier.

The index access methods and index operator classes handle selection of operators for comparisons etc.

answered Jul 3, 2017 at 5:26

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1