Compare the value of a boolean field against any of the values : Boolean « Data Type « PostgreSQL





Compare the value of a boolean field against any of the values


postgres=#
postgres=#
postgres=# CREATE TABLE myTable (isbn text, in_stock boolean);
CREATE TABLE
postgres=#
postgres=# INSERT INTO myTable VALUES ('0385121679', true);
INSERT 0 1
postgres=# INSERT INTO myTable VALUES ('039480001X', 't');
INSERT 0 1
postgres=# INSERT INTO myTable VALUES ('044100590X', 'true');
INSERT 0 1
postgres=# INSERT INTO myTable VALUES ('0451198492', false);
INSERT 0 1
postgres=# INSERT INTO myTable VALUES ('0394900014', '0');
INSERT 0 1
postgres=# INSERT INTO myTable VALUES ('0441172717', '1');
INSERT 0 1
postgres=# INSERT INTO myTable VALUES ('0451160916');
INSERT 0 1
postgres=#
postgres=# select * from myTable;
    isbn    | in_stock
------------+----------
 0385121679 | t
 039480001X | t
 044100590X | t
 0451198492 | f
 0394900014 | f
 0441172717 | t
 0451160916 |
(7 rows)

postgres=#
postgres=# -- Compare the value of a boolean field against any of the values
postgres=#
postgres=# SELECT * FROM myTable WHERE NOT in_stock;
    isbn    | in_stock
------------+----------
 0451198492 | f
 0394900014 | f
(2 rows)

postgres=#
postgres=# drop table myTable;
DROP TABLE
postgres=#
           
       










Related examples in the same category

1.Using the boolean type
2.The difference between true and 'true'
3.Checking Boolean values: yes
4.Implying Boolean 'true'
5.Checking for 'false' Boolean values
6.NOT for boolean value
7.boolean value 't'
8.NULL will not register as either true or false