Clarification on the (lack of) differences between the decimal, dec, and numeric types

public inbox for [email protected]  
help / color / mirror / Atom feed

From: PG Doc comments form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Clarification on the (lack of) differences between the decimal, dec, and numeric types
Date: Thu, 12 Feb 2026 21:06:16 +0000
Message-ID: <[email protected]> (raw)

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.

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Clarification on the (lack of) differences between the decimal, dec, and numeric types
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox