pgSphere 1.1.5

pgSphere development team

pgSphere provides spherical data types, functions, and operators for PostgreSQL.

The project is hosted at pgfoundry.org and https://github.com/akorotkov/pgsphere

This document describes installation and usage of this module.


Table of Contents
1. What is pgSphere?
2. Installation
2.1. Download
2.2. Installation
2.3. Creating a database with pgSphere
3. Data types
3.1. Overview
3.2. Point
3.3. Euler transformation
3.4. Circle
3.5. Line
3.6. Ellipses
3.7. Path
3.8. Polygon
3.9. Coordinates range
4. Constructors
4.1. Point
4.2. Euler transformation
4.3. Circle
4.4. Line
4.5. Ellipse
4.6. Polygon
4.7. Path
4.8. Coordinates range
5. Operators
5.1. Casting
5.2. Equality
5.3. Contain and overlap
5.4. Crossing of lines
5.5. Distance
5.6. Length and circumference
5.7. Center
5.8. Change the direction
5.9. Turn the path of a line
5.10. Transformation
6. Functions
6.1. Area function
6.2. spoint functions
6.3. strans functions
6.4. scircle functions
6.5. sellipse functions
6.6. sline functions
6.7. spath functions
6.8. spoly functions
6.9. sbox functions
7. Create an index
7.1. Spherical index
8. Usage examples
8.1. General
8.2. Geographical
8.3. Astronomical
9. FAQ
10. Appendix
10.1. Changes from version 1.0 to 1.1
10.2. Changes from version 1.1 to 1.1.5