Checking Boolean values: yes : Boolean « Data Type « PostgreSQL






  1. PostgreSQL
  2. Data Type
  3. Boolean

Checking Boolean values: yes


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=# -- Checking Boolean values
postgres=#
postgres=# SELECT * FROM myTable WHERE in_stock = 'yes';
    isbn    | in_stock
------------+----------
 0385121679 | t
 039480001X | t
 044100590X | t
 0441172717 | t
(4 rows)

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








Related examples in the same category

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