Re: [HACKERS] [Q]process for 'contains'.

> i have two question.
> one is
> topological data structure of postgresql.
> i wonder that
> how to related each spatial object-point, polygon, path..
> in postgres.

I'm not certain of your question. Most geometric objects consist of
collections of points. The exception is the circle, which consists of a
point and a radius. In order of complexity, the geometric objects are
point, lseg, line, box, path, polygon, and circle.

> another is..
> process of spatial operator.
> eg: 'contains' search points in polygon.
> how to search??
> how to relate between point table and polygon table.
> (the table has only set of coordinate..)

Hmm. Again not certain of your question, but here are some example
queries using geometric types:

CREATE TABLE pointtbl (name text, location point);
CREATE TABLE polytbl (region text, boundary polygon);

-- find which region each point is in
SELECT p.name, y.region FROM pointtbl p, polytbl y
WHERE p.location @ y.boundary;

> where reference book or site

There is a small description of each geometric type in the new User's
Guide.

- Tom