October 2001
Beginner to intermediate
400 pages
7h 45m
English
The following are various data types that are used less frequently. Often, these are used for internal system purposes only, but you might run across them, so they are listed here for completeness.
The BIT type stores a series of binary-1 and binary-0 values. The BIT data type has a specified width and pads empty entries with zeros, whereas the BIT VARYING data type allows flexible-width entries to be made.
The MONEY data type is still supported but is no longer considered active. Consider using a NUMERIC or DECIMAL data type with an appropriately set decimal width.
The NAME data type stores a 31-character string, but it is only intended to be used internally. PostgreSQL makes use of the NAME ...
Read now
Unlock full access