In this chapter, you covered special data types, including date and time, geospatial, complex data structures, and text data types. For date and time data types, you explored how to manipulate time series data, extract components, and represent the information in practical ways that would allow you to build analysis. For geospatial data types, you learned how to convert latitude and longitude into
POINT data types that allow you to calculate distances between locations.
For complex data types, you explored several powerful data types: arrays, JSON, and JSONB. For these data types, you learned how to create these values, as well as how to write complex queries to navigate their structure.
Finally, you learned that text data can be useful in analytics—first in running an analysis on keywords, and also in the context of text search, which can be a valuable analytical tool.
As your datasets grow larger and larger, these complex analyses become slower and slower...