PostgreSql数据库中布尔类型的用法
1、启动navicat查询窗口，输入如下建表语句
CREATE TABLE "public"."bool_type_test" (
"bool_field" bool
)
;
2、输入如下语句，插入布尔值为真的记录
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('t');
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('true');
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('yes');
INSERT INTO "public"."bool_type_test"("bool_field") VALUES (TRUE);
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('1');
3、输入如下语句，插入布尔值为假的记录
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('f');
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('false');
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('no');
INSERT INTO "public"."bool_type_test"("bool_field") VALUES (FALSE);
INSERT INTO "public"."bool_type_test"("bool_field") VALUES ('0');
4、输入如下语句，可以查询数据库中存储的记录
select * from bool_type_test
