-
Book Overview & Buying
-
Table Of Contents
The Applied SQL Data Analytics Workshop - Second Edition
By :
As previously mentioned, each column in a table has a data type. We review the major data types here.
Numeric data types are data types that represent numbers. The following figure provides an overview of some of the major types:
Figure 1.33: Major numeric data types
Character data types store text information. The following figure summarizes character data types:
Figure 1.34: Major character data types
Under the hood, all of the character data types use the same underlying data structure in PostgreSQL and many other SQL databases, and most modern developers do not use char(n).
Booleans are a data type used to represent True or False. The following table summarizes values that are represented as Boolean when used in a query with a data column type of Boolean:
Figure 1.35: Accepted Boolean values
While all of these values are accepted, the values...