Processing Function and Data Sources
Explore how to apply PostgreSQL's rich set of processing functions for date and time data within SQL queries. Understand the use of the from clause for accessing and joining multiple data sources. Practice with examples that demonstrate complex date computations and combining data from different tables.
We'll cover the following...
We'll cover the following...
PostgreSQL embeds a very rich set of processing functions that can be used anywhere in the queries, even if most of them are more useful in the select clause. Because we see a lot of code fetching only the raw data from the RDBMS and then doing all the processing in the application code, we want to show an example query processing calendar-related information with PostgreSQL.
Functions for date and time
The following query is a showcase for ...