PostgreSQL – Useful Functions PostgreSQL built-in functions, also called as Aggregate functions, are used for performing processing on string or numeric data. The following is the list of all general-purpose PostgreSQL built-in functions − − The PostgreSQL COUNT aggregate function is used to count the number of rows in a database table. − The PostgreSQL […]
Author Archives: user
PostgreSQL – Functions PostgreSQL functions, also known as Stored Procedures, allow you to carry out operations that would normally take several queries and round trips in a single function within the database. Functions allow database reuse as other applications can interact directly with your stored procedures instead of a middle-tier or duplicating code. Functions can […]
PostgreSQL – DATE/TIME Functions and Operators We had discussed about the Date/Time data types in the chapter . Now, let us see the Date/Time operators and Functions. The following table lists the behaviors of the basic arithmetic operators − Operator Example Result + date ”2001-09-28” + integer ”7” date ”2001-10-05” + date ”2001-09-28” + interval […]