PostgreSQL锟结供锟斤拷准锟斤拷SQL锟斤拷锟斤拷boolean锟斤拷锟轿硷拷锟斤拷 8-19锟斤拷boolean锟斤拷锟斤拷锟叫讹拷锟阶刺拷锟�"true锟斤拷锟芥）"锟斤拷"false锟斤拷锟劫ｏ拷"锟酵碉拷锟斤拷锟斤拷状态"unknown锟斤拷未知锟斤拷"锟斤拷未知状态锟斤拷SQL锟斤拷值锟斤拷示锟斤拷
锟斤拷 8-19. 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
| 锟斤拷锟斤拷 | 锟芥储锟街斤拷 | 锟斤拷锟斤拷 |
|---|
| boolean | 1锟街斤拷 | 状态为锟斤拷锟斤拷 |
"锟斤拷"状态锟斤拷锟斤拷效锟斤拷锟斤拷值锟角ｏ拷
| TRUE |
| 't' |
| 'true' |
| 'y' |
| 'yes' |
| 'on' |
| '1' |
锟斤拷锟斤拷锟斤拷
"锟斤拷"状态锟斤拷锟斤拷锟斤拷锟绞癸拷锟斤拷锟斤拷锟斤拷锟叫┲碉拷锟�
| FALSE |
| 'f' |
| 'false' |
| 'n' |
| 'no' |
| 'off' |
| '0' |
前锟斤拷锟斤拷锟斤拷末尾锟侥空白斤拷锟斤拷锟斤拷锟皆ｏ拷锟斤拷锟揭达拷小写也锟睫关斤拷要锟斤拷使锟斤拷
TRUE锟斤拷
FALSE锟斤拷锟斤拷锟侥关硷拷锟绞比较好ｏ拷
SQL锟斤拷锟捷ｏ拷锟斤拷
锟斤拷 8-2锟斤拷示锟斤拷使锟斤拷锟斤拷母t锟斤拷f锟斤拷锟�boolean值锟斤拷锟斤拷锟接★拷
锟斤拷 8-2. 使锟斤拷boolean锟斤拷锟斤拷
CREATE TABLE test1 (a boolean, b text);
INSERT INTO test1 VALUES (TRUE, 'sic est');
INSERT INTO test1 VALUES (FALSE, 'non est');
SELECT * FROM test1;
a | b
---+---------
t | sic est
f | non est
SELECT * FROM test1 WHERE a;
a | b
---+---------
t | sic est