Returns regions containing a given point |
The parameters Possible types are: SEGMENT STRIPE TIGEOM PLATE CAMCOL RUN STAVE CHUNK TILE TILEBOX SECTOR SECTORLET SKYBOX WEDGE. Returns a table with the coulums Returns empty table if input params are bad. RegionID BIGINT NOT NULL PRIMARY KEY Type VARCHAR(16) NOT NULL SELECT * from fGetRegionsContainingPointXYZ(0,0,0,'STAVE',0) |
name | type | length | inout | pnum |
@x | float | 8 | input | 1 |
@y | float | 8 | input | 2 |
@z | float | 8 | input | 3 |
@buffer | float | 8 | input | 5 |
@types | varchar | 1000 | input | 4 |
regionid | bigint | 8 | output | 1 |
type | varchar | 16 | output | 2 |