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

Home
PostgreSQL
1.Aggregate Functions
2.Analytical Functions
3.Array
4.Constraints
5.Cursor
6.Data Type
7.Database
8.Date Timezone
9.Index
10.Inheritance
11.Insert Delete Update
12.Math Functions
13.Postgre SQL
14.Select Query
15.Sequence
16.Store Procedure Function
17.String Functions
18.Subquery
19.Table
20.Table Joins
21.Transaction
22.User Previliege
23.View
PostgreSQL » Data Type » Boolean 
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 |
(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
(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
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.