Geometric Types PostgreSQL Prev Chapter 3. Next Geometric Types Geometric types represent two-dimensional spatial objects. The most fundamental type, the point, forms the basis for all of the other types. A rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. Point Points are the fundamental two-dimensional building block for geometric types.
Boxes are output using the first syntax.
The corners are reordered on input to store the lower left corner first and the upper right corner last. Other corners of the box can be entered, but the lower left and upper right corners are determined from the input and stored. Path Paths are represented by connected sets of points. Polygon Polygons are represented by sets of points. Polygons should probably be considered equivalent to closed paths, but are stored differently and have their own set of support routines.