Chapter 2. PostgreSQL Data Types
Data types are the basic building blocks of any RDBMS. They provide the mechanisms needed for the higher-level functionality of modern databases to exist. Queries, data validation, comparison operators, manipulation functions, and so on exist only as an extension of the data-type concept.
Without data types, it would be extremely difficult to consistently obtain meaningful information from a database. Data types ensure that data at the columnar level is stored in a consistent format. This facilitates the capability to make comparisons and manipulation of the underlying data in a predictable manner. Without such consistency, it could be like comparing apples and oranges (or integers and strings, in this case) ...
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
