| PostgreSQL 9.6.0 锟街诧拷
| |||
|---|---|---|---|
| 锟斤拷一页 | 锟斤拷一锟斤拷 | 锟斤拷 9. 锟斤拷锟斤拷锟酵诧拷锟斤拷锟斤拷 | 锟斤拷一页 |
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟节硷拷锟酵诧拷锟斤拷位锟斤拷锟侥猴拷锟斤拷锟酵诧拷锟斤拷锟斤拷锟斤拷也锟斤拷锟角诧拷锟斤拷锟斤拷锟斤拷为bit锟斤拷bit varying锟斤拷值锟侥猴拷锟斤拷锟酵诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟剿筹拷锟矫的比较诧拷锟斤拷锟斤拷之锟解，锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷 9-13锟斤拷锟斤拷示锟侥诧拷锟斤拷锟斤拷锟斤拷&锟斤拷|锟斤拷#锟斤拷位锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷瘸锟斤拷锟斤拷锟斤拷锟轿伙拷锟绞憋拷颍锟斤拷锟皆硷拷锟轿伙拷锟斤拷牡某锟斤拷龋锟斤拷锟斤拷锟斤拷锟斤拷锟绞撅拷锟�
锟斤拷 9-13. 位锟斤拷锟斤拷锟斤拷锟斤拷
| 锟斤拷锟斤拷锟斤拷 | 锟斤拷锟斤拷 | 锟斤拷锟斤拷 | 锟斤拷锟� |
|---|---|---|---|
| || | 锟斤拷锟斤拷 | B'10001' || B'011' | 10001011 |
| & | 锟斤拷位锟斤拷 | B'10001' & B'01101' | 00001 |
| | | 锟斤拷位锟斤拷 | B'10001' | B'01101' | 11101 |
| # | 锟斤拷位锟斤拷锟� | B'10001' # B'01101' | 11100 |
| ~ | 锟斤拷位锟斤拷 | ~ B'10001' | 01110 |
| << | 锟斤拷位锟斤拷锟斤拷 | B'10001' << 3 | 01000 |
| >> | 锟斤拷位锟斤拷锟斤拷 | B'10001' >> 2 | 00100 |
锟斤拷锟斤拷锟�SQL锟斤拷准锟斤拷锟斤拷锟斤拷锟剿匡拷锟斤拷锟斤拷锟斤拷锟街凤拷锟斤拷之锟解，也锟斤拷锟斤拷锟斤拷锟斤拷位锟斤拷锟斤拷
length锟斤拷
bit_length锟斤拷
octet_length锟斤拷
position锟斤拷
substring锟斤拷
overlay锟斤拷
锟斤拷锟斤拷暮锟斤拷锟斤拷锟斤拷丝锟斤拷锟斤拷锟斤拷诙锟斤拷锟斤拷拼锟街拷猓诧拷锟斤拷锟斤拷锟斤拷锟轿伙拷锟斤拷锟�
get_bit锟斤拷
set_bit锟斤拷
锟斤拷使锟斤拷锟斤拷一锟斤拷位锟斤拷时锟斤拷锟斤拷些锟斤拷锟斤拷锟斤拷锟斤拷锟侥碉拷一锟斤拷锟斤拷锟斤拷位锟斤拷锟斤拷为位 0锟斤拷
锟斤拷锟解，锟斤拷锟角匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷bit之锟斤拷锟斤拷锟斤拷转锟斤拷锟斤拷一些锟斤拷锟接ｏ拷
44::bit(10) 0000101100 44::bit(3) 100 cast(-44 as bit(12)) 111111010100 '1110'::bit(4)::integer 14
锟斤拷注锟解，锟斤拷锟街伙拷锟阶拷锟轿�"bit"锟斤拷锟斤拷思锟斤拷转锟斤拷锟斤拷bit(1)锟斤拷锟斤拷锟街伙拷锟阶拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷效位锟斤拷
注锟斤拷: 锟斤拷一锟斤拷锟斤拷锟斤拷转锟斤拷锟斤拷bit(n)锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭边碉拷n位锟斤拷 锟斤拷一锟斤拷锟斤拷锟斤拷转锟斤拷锟缴憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷位锟斤拷锟斤拷锟酵伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷拧锟�