Re: [GENERAL] Column information - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Column information
Date
Msg-id 10391.1493912968@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Column information  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> Think I answered my own question. Numeric refers to all the types under:
> https://www.postgresql.org/docs/9.6/static/datatype-numeric.html
> not just the specific type numeric.

Right.  This overloading of the term "numeric" is a bit unfortunate,
but it's not all our fault, because the SQL standard does the same
thing --- for instance they write

    — The data types NUMERIC, DECIMAL, SMALLINT, INTEGER, and BIGINT are
      collectively referred to as exact numeric types.
    — The data types FLOAT, REAL, and DOUBLE PRECISION are collectively
      referred to as approximate numeric types.
    — Exact numeric types and approximate numeric types are collectively
      referred to as numeric types. Values of numeric types are referred
      to as numbers.

            regards, tom lane


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Column information
Next
From: Igor Korot
Date:
Subject: Re: [GENERAL] Column information