Skip to content

Tag Archives: postgreSQL-operators

PostgreSQL provides you with CASE statements that allow you to execute a block of code conditionally. There are two forms of the CASE statement:  Simple… Read More
PostgreSQL has an IF statement executes `statements` if a condition is true. If the condition evaluates to false, the control is passed to the next… Read More
In PostgreSQL, the COALESCE function returns the first non-null argument. It is generally used with the SELECT statement to handle null values effectively. Syntax: COALESCE… Read More
PostgreSQL has an ANY operator that is used to compare a scalar value with a set of values returned by a subquery. Syntax: expression operator… Read More
In PostgreSQL, the EXCEPT operator is used to return distinct rows from the first (left) query that are not in the output of the second… Read More
PostgreSQL has an INTERSECT operator that is used to combine two or more result sets returned by the SELECT statement and provide with the common… Read More
The PostgreSQL UNION operator is used to combine result sets of multiple queries into a single set of result. It is used to combine result… Read More
PostgreSQL BETWEEN operator is used to match a value against a range of values. Syntax: value BETWEEN low AND high; Or, Syntax: value >= low… Read More
PostgreSQL NOT BETWEEN operator is used to match all values against a range of values excluding the values in the mentioned range itself. Syntax: value… Read More
The PostgreSQL LIKE operator is used query data using pattern matching techniques. Its result include strings that are case-sensitive and follow the mentioned pattern. It… Read More
The PostgreSQL IS NULL operator is used to check if a value is NULL or not. In the world of database Null either means data… Read More
The PostgreSQL ILIKE operator is used query data using pattern matching techniques. Its result include strings that are case-insensitive and follow the mentioned pattern. It… Read More
The PostgreSQL NOT LIKE works exactly opposite to that of the LIKE operator. It is used to data using pattern matching techniques that explicitly excludes… Read More
PostgreSQL has multiple ways to create a database. In this article we will discuss multiple ways to do so. 1. Using psql Shell: To create… Read More
In PostgreSQL, the EXISTS operator is used to test for the existence of rose in a subquery.It is generally used with correlated subqueries. If the… Read More