CREATE TYPE PolyType AS ARRAY(5000) OF Point CREATE TYPE Polygon AS OBJECT( Num_of_point int, Geometry polyType, MEMBER FUNCTION Area(SELF IN) RETURN MEMBER, PRAGMA RESTRICT_REFERENCES(Length,WNDS)); CREATE TABLE census_block ( block_id varchar(50), area number, population int, shape Polygon) |
Última modificación: Thursday, 24 de November de 2005, 15:31