Similar Topics

Web Technologies32.1K+ articles

DSA20.5K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

JavaScript9.9K+ articles

Misc7.7K+ articles

Databases1.9K+ articles

PostgreSQL386+ articles

postgreSQL-operators

19 posts

PostgreSQL - CASE Statement

Last Updated: 15 July 2025

In PostgreSQL, CASE statements provide a way to implement conditional logic within SQL queries. Using these statements effectively can help streamline database functions, ...read more

postgreSQL-operators

PostgreSQL - IF Statement

Last Updated: 28 July 2026

The PostgreSQL IF statement is a conditional statement used in PL/pgSQL blocks, functions, procedures and triggers to execute different statements based on specified condi...read more

article_image

postgreSQL-operators

PostgreSQL COALESCE

Last Updated: 28 July 2026

The PostgreSQL COALESCE() function is used to handle NULL values by evaluating multiple expressions and returning the first available non-NULL value. It helps produce more...read more

article_image

postgreSQL-operators

Create Database in PostgreSQL

Last Updated: 17 June 2026

Creating a database in PostgreSQL allows users to store, organize and manage related data in a separate database environment.Supports multiple databases on one server.Cont...read more

article_image

postgreSQL-operators

PostgreSQL - EXISTS Operator

Last Updated: 28 July 2026

The EXISTS operator in PostgreSQL is used to check whether a subquery returns any rows. It returns TRUE if the subquery returns one or more rows; otherwise, it returns FAL...read more

postgreSQL-operators

PostgreSQL - ALL Operator

Last Updated: 01 August 2026

The ALL operator in PostgreSQL is used to compare a value with a set of values returned by a subquery or an array. The condition evaluates to TRUE only if the comparison i...read more

article_image

postgreSQL-operators

PostgreSQL - SOME Operator

Last Updated: 12 July 2025

The PostgreSQL SOME operator is used to compare a scalar value with a set of values returned by a subquery. This operator is useful for performing conditional checks again...read more

article_image

postgreSQL-operators

PostgreSQL - ANY Operator

Last Updated: 28 July 2026

The ANY operator in PostgreSQL is used to compare a value with a set of values returned by a subquery or an array. The condition evaluates to TRUE if at least one value in...read more

article_image

postgreSQL-operators

PostgreSQL - EXCEPT Operator

Last Updated: 01 August 2026

The EXCEPT operator in PostgreSQL returns the rows from the first query that do not appear in the second query. It is used to compare two result sets and identify records ...read more

postgreSQL-operators

PostgreSQL - INTERSECT Operator

Last Updated: 24 July 2026

The INTERSECT operator in PostgreSQL is used to return the rows that are common to the results of two or more SELECT queries.Removes duplicate rows automatically.Requires ...read more

article_image

postgreSQL-operators

PostgreSQL - UNION operator

Last Updated: 17 July 2026

The UNION operator in PostgreSQL is used to combine the results of two or more SELECT statements into a single result set. It automatically removes duplicate rows from the...read more

postgreSQL-operators

PostgreSQL - BETWEEN Operator

Last Updated: 17 July 2026

The BETWEEN operator in PostgreSQL is used to filter rows where a column value falls within a specified range. The range is inclusive, meaning both the starting and ending...read more

article_image

postgreSQL-operators

PostgreSQL - NOT BETWEEN operator

Last Updated: 12 July 2025

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

article_image

postgreSQL-operators

PostgreSQL - LIKE operator

Last Updated: 28 July 2026

The PostgreSQL LIKE operator searches for a specified pattern in a text value. It is commonly used with wildcard characters to perform flexible string matching in SQL quer...read more

article_image

postgreSQL-operators

PostgreSQL - IS NULL operator

Last Updated: 01 August 2026

The IS NULL operator in PostgreSQL is used to find rows where a column contains a NULL value. A NULL value represents missing, unknown, or undefined data. It is different ...read more

postgreSQL-operators

1 2