Data Types

Boolean Type

Boolean

Numerical Types

Integer

smallint, int, bigint

Numeric (aka Decimal)

numeric(precision, scale) [Always specify precision and scale.]

Floating Point

real, double precision

Numeric and Floating Points offers -Infinity, Infinity, NaN

Textual Types

Character

char(n)

Character Varying

varchar(n), varchar()

Text

Temporal Types

Date

Time Stamp Without Time Zone

timestamp [Offers -Infinity and Infinity]

Time Stamp With Time Zone

timestamptz [Offers -Infinity and Infinity]

Interval

JSON Type

JSON

JSONB

You can use full type name or abbreviated type name. For instance, both character varying(10) and varchar(10) will work.

All data types may be casted to text.

Integers

Rounding

• Locate place to round to. (Target)
• Is the number to the right [5,9]? If so, round up target. Iteratively round.
• Is the number to the right [0,4]? Zero out target.
• Retain zero to target for clarity
• Pad zeros if necessary.

Castability to Numeric (Precision, Scale)

1. Round to Scale
2. Result must be WITHIN absolute value of 10 ^{(Precision - Scale)}

Range of Real and Double Precision