{"id":1002,"date":"2024-12-16T14:27:47","date_gmt":"2024-12-16T07:27:47","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=1002"},"modified":"2025-01-05T19:49:19","modified_gmt":"2025-01-05T12:49:19","slug":"postgresql-bool_and","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-aggregate-functions\/postgresql-bool_and\/","title":{"rendered":"PostgreSQL BOOL_AND Aggregate Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the PostgreSQL BOOL_AND()<\/code> aggregate function to return true<\/code> if all values in a set of values are true<\/code>.<\/p>\n\n\n\n

Getting Started with the PostgreSQL BOOL_AND aggregate function #<\/a><\/h2>\n\n\n\n

In PostgreSQL, the BOOL_AND<\/code> is an aggregate function that takes a set of boolean<\/a> values and returns a single value.<\/p>\n\n\n\n

If all values are true<\/code>, then BOOL_AND<\/code> returns true<\/code>. If any value is false<\/code>, the BOOL_AND<\/code> aggregate function returns false<\/code>.<\/p>\n\n\n\n

Here’s the syntax of the BOOL_AND<\/code> aggregate function:<\/p>\n\n\n

SELECT<\/span>\n  BOOL_AND (column1)\nFROM<\/span>\n  table_name<\/span>;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the BOOL_AND<\/code> function takes all boolean values in column1<\/code> and returns true<\/code> if all values are true<\/code> or false<\/code> if any of the values are false<\/code>. <\/p>\n\n\n\n
The data type of column1<\/code> must be boolean. If it is not, then you need to cast the values to boolean explicitly.<\/p>\n\n\n\n
Note that the BOOL_AND<\/code> function ignores NULLs.<\/p>\n\n\n\n
PostgreSQL BOOL_AND Aggregate Function Examples #<\/a><\/h2>\n\n\n\n
\"PostgreSQL<\/figure>\n\n\n\n
The following statement uses the BOOL_AND<\/code> aggregate function to check if all products have safety stock greater than zero:<\/p>\n\n\n
SELECT<\/span>\n  BOOL_AND (safety_stock > 0<\/span>)\nFROM<\/span>\n  products;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
 bool_and\n----------<\/span>\n f<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output indicates that one or more products have a safety stock of zero.<\/p>\n\n\n\n
In this example:<\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n