| PostgreSQL 9.6.0 锟街诧拷
| |||
|---|---|---|---|
| 锟斤拷一页 | 锟斤拷一锟斤拷 | 锟斤拷 8. 锟斤拷锟斤拷锟斤拷锟斤拷 | 锟斤拷一页 |
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵憋拷示锟斤拷维锟侥空硷拷锟斤拷锟藉。锟斤拷 8-20展示锟斤拷PostgreSQL锟叫匡拷锟斤拷锟矫的硷拷锟斤拷锟斤拷锟酵★拷
锟斤拷 8-20. 锟斤拷锟斤拷锟斤拷锟斤拷
| 锟斤拷锟斤拷 | 锟芥储锟竭达拷 | 锟斤拷示 | 锟斤拷锟斤拷 |
|---|---|---|---|
| point | 16锟街斤拷 | 平锟斤拷锟较的碉拷 | (x,y) |
| line | 32锟街斤拷 | 锟斤拷锟睫筹拷锟斤拷锟斤拷 | {A,B,C} |
| lseg | 32锟街斤拷 | 锟斤拷锟斤拷锟竭讹拷 | ((x1,y1),(x2,y2)) |
| box | 32锟街斤拷 | 锟斤拷锟轿匡拷 | ((x1,y1),(x2,y2)) |
| path | 16+16n锟街斤拷 | 锟斤拷锟铰凤拷锟斤拷锟斤拷锟斤拷锟斤拷诙锟斤拷锟轿ｏ拷 | ((x1,y1),...) |
| path | 16+16n锟街斤拷 | 锟斤拷锟斤拷路锟斤拷 | [(x1,y1),...] |
| polygon | 40+16n锟街斤拷 | 锟斤拷锟斤拷危锟斤拷锟斤拷锟斤拷诜锟斤拷路锟斤拷锟斤拷 | ((x1,y1),...) |
| circle | 24锟街斤拷 | 圆 | <(x,y),r> (center point and radius) |
锟斤拷锟斤拷锟斤拷一系锟叫丰富锟侥猴拷锟斤拷锟酵诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫革拷锟街硷拷锟轿诧拷锟斤拷锟斤拷 锟斤拷锟斤拷锟脚★拷平锟狡★拷锟斤拷转锟酵硷拷锟斤拷锟洁交锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷 9.11 锟斤拷锟叫斤拷锟酵★拷
锟斤拷锟角硷拷锟斤拷锟斤拷锟酵的伙拷锟斤拷锟斤拷维锟斤拷锟斤拷椤ｏ拷锟斤拷锟斤拷锟斤拷锟斤法锟斤拷锟斤拷point锟斤拷锟酵碉拷值锟斤拷
( x , y ) x , y
锟斤拷锟斤拷x锟斤拷y锟街憋拷锟斤拷锟斤拷锟疥，锟斤拷锟角革拷锟斤拷锟斤拷锟斤拷
锟斤拷使锟矫碉拷一锟斤拷锟斤法锟斤拷锟斤拷锟�
锟斤拷锟斤拷锟斤拷锟皆凤拷锟斤拷Ax + By + C = 0 锟斤拷示锟斤拷锟斤拷锟斤拷A锟斤拷B锟斤拷锟斤拷为锟姐。锟斤拷锟斤拷line 锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷式锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
{ A, B, C }锟斤拷锟解，锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷式锟斤拷锟诫：
[ ( x1 , y1 ) , ( x2 , y2 ) ]
( ( x1 , y1 ) , ( x2 , y2 ) )
( x1 , y1 ) , ( x2 , y2 )
x1 , y1 , x2 , y2锟斤拷锟斤拷 (x1,y1) 锟斤拷 (x2,y2) 锟斤拷锟斤拷锟较诧拷同锟斤拷锟斤拷锟姐。
锟竭讹拷锟斤拷一锟斤拷锟竭段的端碉拷锟斤拷锟斤拷示锟斤拷lseg锟斤拷锟酵碉拷值锟斤拷锟斤拷锟斤拷锟斤拷锓拷锟斤拷锟斤拷锟�
[ ( x1 , y1 ) , ( x2 , y2 ) ]
( ( x1 , y1 ) , ( x2 , y2 ) )
( x1 , y1 ) , ( x2 , y2 )
x1 , y1 , x2 , y2锟斤拷锟斤拷(x1,y1) 锟斤拷 (x2,y2) 锟斤拷锟竭段的端点。
锟竭讹拷使锟矫碉拷一锟斤拷锟斤法锟斤拷锟斤拷锟�
锟斤拷锟斤拷锟斤拷锟斤拷越堑牡锟皆憋拷示锟斤拷box锟斤拷锟酵碉拷值使锟斤拷锟斤拷锟斤拷锟斤拷锓ㄖ革拷锟斤拷锟�
( ( x1 , y1 ) , ( x2 , y2 ) )
( x1 , y1 ) , ( x2 , y2 )
x1 , y1 , x2 , y2锟斤拷锟斤拷(x1,y1) 锟斤拷 (x2,y2) 锟角凤拷锟斤拷亩越堑恪�
锟斤拷锟斤拷使锟矫第讹拷锟斤拷锟斤法锟斤拷锟斤拷锟�
锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟结供锟斤拷锟斤拷锟斤拷锟斤拷锟皆角ｏ拷锟斤拷锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷要锟斤拷锟斤拷顺锟斤拷锟铰嘉拷锟斤拷辖呛锟斤拷锟斤拷陆恰锟�
路锟斤拷锟斤拷一系锟斤拷锟斤拷锟接的碉拷锟斤拷伞锟铰凤拷锟斤拷锟斤拷锟斤拷锟�锟斤拷锟斤拷锟侥ｏ拷也锟斤拷锟斤拷锟斤拷为锟叫憋拷锟叫碉拷一锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷没锟叫憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷也锟斤拷锟斤拷锟斤拷锟斤拷锟�锟侥ｏ拷锟斤拷时锟斤拷为锟斤拷一锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷惚伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
path锟斤拷锟酵碉拷值锟斤拷锟斤拷锟斤拷锟斤拷锓拷锟斤拷锟斤拷锟�
[ ( x1 , y1 ) , ... , ( xn , yn ) ]
( ( x1 , y1 ) , ... , ( xn , yn ) )
( x1 , y1 ) , ... , ( xn , yn )
( x1 , y1 , ... , xn , yn )
x1 , y1 , ... , xn , yn锟斤拷锟叫的碉拷锟斤拷锟斤拷锟铰凤拷锟斤拷锟斤拷叨蔚亩说恪ｏ拷锟斤拷锟斤拷锟斤拷锟�[]锟斤拷锟斤拷示一锟斤拷锟斤拷锟脚碉拷路锟斤拷锟斤拷圆锟斤拷锟斤拷锟斤拷()锟斤拷锟斤拷示一锟斤拷锟斤拷盏锟铰凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街碉拷锟斤拷锟斤拷锟斤拷锟斤法锟斤拷示锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆诧拷锟斤拷疟锟斤拷锟斤拷锟绞憋拷锟铰凤拷锟斤拷锟斤拷锟斤拷俣锟轿拷锟秸★拷
路锟斤拷锟斤拷锟斤拷锟绞癸拷玫锟揭伙拷只锟节讹拷锟斤拷锟斤法锟斤拷
锟斤拷锟斤拷锟斤拷锟揭幌碉拷械锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷蔚亩锟斤拷悖╋拷锟斤拷锟斤拷锟轿和凤拷锟铰凤拷锟斤拷锟斤拷瘢锟斤拷谴娲拷锟绞斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷约锟斤拷锟揭伙拷锟街э拷锟斤拷锟斤拷獭锟�
polygon锟斤拷锟酵碉拷值锟斤拷锟斤拷锟斤拷锟斤法锟斤拷锟斤拷锟斤拷
( ( x1 , y1 ) , ... , ( xn , yn ) )
( x1 , y1 ) , ... , ( xn , yn )
( x1 , y1 , ... , xn , yn )
x1 , y1 , ... , xn , yn锟斤拷锟叫的碉拷锟斤拷锟斤拷啥锟斤拷锟轿边斤拷锟斤拷叨蔚亩说恪�
锟斤拷锟斤拷蔚锟斤拷锟斤拷使锟矫碉拷一锟斤拷锟斤法锟斤拷
圆锟斤拷一锟斤拷圆锟侥猴拷一锟斤拷锟诫径锟斤拷锟斤拷锟斤拷circle锟斤拷锟酵碉拷值锟斤拷锟斤拷锟斤拷锟斤拷锓ㄖ革拷锟斤拷锟�
< ( x , y ) , r >
( ( x , y ) , r )
( x , y ) , r
x , y , r锟斤拷锟斤拷(x,y)锟斤拷圆锟侥ｏ拷锟斤拷r锟斤拷圆锟侥半径锟斤拷
圆锟斤拷锟斤拷锟斤拷玫锟揭伙拷锟斤拷锓拷锟�