PostgreSQL Tutorial: Functions
Summary: This tutorial introduces you to the PostgreSQL functions and shows you how to use them effectively.
PostgreSQL Tutorial: CLOCK_TIMESTAMP Function
Summary: The PostgreSQL CLOCK_TIMESTAMP() function returns the current date and time with time zone, which is the time when the function executes.
PostgreSQL Tutorial: STATEMENT_TIMESTAMP Function
Summary: The PostgreSQL STATEMENT_TIMESTAMP() function returns the current date and time with time zone, which is the time when the current statement starts.
PostgreSQL Tutorial: Aggregate Functions
Summary: in this tutorial, you will learn how to use the PostgreSQL aggregate functions such as AVG(), COUNT(), MIN(), MAX(), and SUM().
PostgreSQL Tutorial: Date Functions
The following page shows the most commonly used PostgreSQL date functions that allow you to manipulate date and time values effectively.
PostgreSQL Tutorial: Math Functions
This page provides you with the most commonly used PostgreSQL Math functions that help you perform various math operations quickly and effectively.
PostgreSQL Tutorial: String Functions
This page provides you with the most commonly used PostgreSQL string functions that allow you to manipulate string data effectively.
PostgreSQL Tutorial: Window Functions
Summary: in this tutorial, you will learn how to use the PostgreSQL window functions to perform the calculation across a set of rows related to the current row.
PostgreSQL Tutorial: TRANSLATE Function
The PostgreSQL TRANSLATE() function performs several single-character, one-to-one translation in one operation.
PostgreSQL Tutorial: AGE Function: Calculate Ages
Summary: in this tutorial, you will learn how to use the PostgreSQL AGE() function to calculate ages.