function

PostgreSQL Tutorial: REPEAT Function

Summary: in this tutorial, you will learn how to use the PostgreSQL REPEAT() function to repeat a string a specified number of times.

Continue reading

PostgreSQL Tutorial: REVERSE Function

Summary: in this tutorial, you will learn how to use the PostgreSQL REVERSE() function to reverse the characters within a string.

Continue reading

PostgreSQL Tutorial: Functions

Summary: This tutorial introduces you to the PostgreSQL functions and shows you how to use them effectively.

Continue reading

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.

Continue reading

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.

Continue reading

PostgreSQL Tutorial: TRANSLATE Function

Summary: The PostgreSQL TRANSLATE() function performs several single-character, one-to-one translation in one operation.

Continue reading

PostgreSQL Tutorial: AGE Function: Calculate Ages

Summary: In this tutorial, you will learn how to use the PostgreSQL AGE() function to calculate ages.

Continue reading

PostgreSQL Tutorial: ASCII Function: Get ASCII code or Unicode Code Point of a Character

Summary: The PostgreSQL ASCII() function returns an ASCII code value of a character. In the case of UTF-8, the ASCII() function returns the Unicode code point of the character.

Continue reading

PostgreSQL Tutorial: CHR Function: Get Character Based on ASCII or Unicode Code Point

Summary: The PostgreSQL CHR() function converts an integer ASCII code to a character or a Unicode code point to a UTF8 character.

Continue reading

PostgreSQL Tutorial: CURRENT_DATE Function

Summary: The PostgreSQL CURRENT_DATE function returns the current date.

Continue reading