Similar Topics

570+ articles

230+ articles

postgreSQL-operators

10+ posts

Popular articles

Recent articles

PostgreSQL - CASE Statement

Last updated: 28 August 2020

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 CASE statementSearch ...read more

postgreSQL-operators

PostgreSQL - IF Statement

Last updated: 22 February 2022

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 statement after the END ...read more

postgreSQL-operators

PostgreSQL - COALESCE

Last updated: 28 August 2020

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-operators

Similar Topics

570+ articles

230+ articles

PostgreSQL - ANY Operator

Last updated: 28 August 2020

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 ANY(subquery)The below rules ...read more

postgreSQL-operators

PostgreSQL - EXCEPT Operator

Last updated: 28 August 2020

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 (right) query while comparing resul...read more

postgreSQL-operators

PostgreSQL - UNION operator

Last updated: 28 August 2020

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 sets of two or more SELECT state...read more

postgreSQL-operators

PostgreSQL - BETWEEN operator

Last updated: 28 August 2020

PostgreSQL BETWEEN operator is used to match a value against a range of values.Syntax: value BETWEEN low AND high;Or,Syntax: value >= low and value;The BETWEEN operator is...read more

postgreSQL-operators

PostgreSQL - NOT BETWEEN operator

Last updated: 19 September 2023

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 NOT BETWEEN low AND ...read more

postgreSQL-operators

PostgreSQL - LIKE operator

Last updated: 28 August 2020

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 i...read more

postgreSQL-operators

PostgreSQL - ILIKE operator

Last updated: 19 September 2023

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.I...read more

postgreSQL-operators

PostgreSQL - NOT LIKE operator

Last updated: 28 August 2020

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 the mentioned pa...read more

postgreSQL-operators

PostgreSQL - Create Database

Last updated: 28 August 2020

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 a database through the psql shell w...read more

postgreSQL-operators

PostgreSQL - EXISTS Operator

Last updated: 18 April 2023

In PostgreSQL, the EXISTS operator is used to test for the existence of rows in a subquery.It is generally used with correlated subqueries. If the subquery returns at leas...read more

postgreSQL-operators

PostgreSQL - IN operator

Last updated: 28 August 2020

The PostgreSQL IN operator is used with the WHERE clause to check against a list of values.The syntax for using IN operator with the WHERE clause to check against a list o...read more

postgreSQL-operators

PostgreSQL - NOT IN operator

Last updated: 28 August 2020

The PostgreSQL NOT IN operator works exactly opposite to that of the IN operator. It is used to filter query results excluding the specified values from the list of values...read more

postgreSQL-operators