October 2001
Beginner to intermediate
400 pages
7h 45m
English
PostgreSQL includes a number of built-in data types for holding geometric-based data. There are also many built-in functions and operators that aid in the manipulation and calculation of geometric data.
Holds the outer-corner coordinates that define a rectangle.
((x1,y1),(x2,y2))
x1—X-axis begin point.
y1—Y-axis begin point.
x2—X-axis end point.
y2—Y-axis end point.
32 bytes
((1,1),(50,50))
On input, the data is reordered to store the lower-right corner first and the upper-left corner second.Therefore, the preceding example, when stored, would be represented as (50,50),(1,1).
Holds the coordinates that represent a center point and radius ...
Read now
Unlock full access