PostgreSQL And – Or

PostgreSQL And – Or

AND returns query rows if both conditions are true.
OR returns query rows if at least one of the conditions is true.

And – Or syntax

SELECT * FROM table_name WHERE condition AND condition;

SELECT * FROM table_name WHERE condition OR condition;

SELECT * FROM table_name WHERE condition AND condition OR condition;

And – Or example

Goods table

idgood_typenamedescriptionpriceinsert_date
1ACar_1Car 1 description1002018-07-21 08:45:57.311809
2ACar_2Car 2 description2002018-07-21 08:45:57.311809
3ACar_3Car 3 description1002018-07-21 08:45:57.311809
4BBoat_4Boat 4 description5002018-07-21 08:45:57.311809
5BBoat_5Boat 5 description3002018-07-21 08:45:57.311809
6CTrain_1Train 123 description8002018-07-21 08:45:57.311809
SELECT * FROM goods WHERE good_type = 'A' and price=100;

Result

idgood_typenamedescriptionpriceinsert_date
1ACar_1Car 1 description1002018-07-21 08:45:57.311809
3ACar_3Car 3 description1002018-07-21 08:45:57.311809
SELECT * FROM goods WHERE good_type = 'C' or price=300;

Result

idgood_typenamedescriptionpriceinsert_date
5BBoat_5Boat 5 description3002018-07-21 08:45:57.311809
6CTrain_1Train 123 description8002018-07-21 08:45:57.311809