Clarification on the (lack of) differences between the decimal, dec, and numeric types - Mailing list pgsql-docs

From PG Doc comments form
Subject Clarification on the (lack of) differences between the decimal, dec, and numeric types
Date
Msg-id 177093037652.511554.9909015222857903383@wrigleys.postgresql.org
Whole thread Raw
Responses Re: Clarification on the (lack of) differences between the decimal, dec, and numeric types
List pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/datatype-numeric.html
Description:

I would like to clarify the language describing the decimal type on this
page: https://www.postgresql.org/docs/current/datatype-numeric.html

The above page states that "The types decimal and numeric are equivalent."
Although this is correct, it is not precise enough. Several questions have
been asked online about the difference between the types, even though there
is no difference. decimal and dec are both aliases to the numeric type. Any
calls to decimal or dec are the same thing as calls to numeric.

I suggest changing the wording of the page to read "decimal is an alias of
the type numeric. Both reference the same underlying type."

This answer on StackOverflow explains the full details:
https://stackoverflow.com/a/79888387/9542182.




pgsql-docs by date:

Previous
From: Lukas Fittl
Date:
Subject: Re: "Disadvantages of increasing autovacuum_freeze_max_age" paragraph to be modified
Next
From: "David G. Johnston"
Date:
Subject: Re: Clarification on the (lack of) differences between the decimal, dec, and numeric types