3.9. Coordinates range
Prev | Up | Chapter 3. Data Types | Home | Next

## 3.9. Coordinates range #

A spherical box is a coordinates range. Hence, you can select objects within a longitude range and latitude range. The box is represented using two spherical points: the southwest (`pos_sw`) and the northeast (`pos_ne`) edge of the box. The input syntax is:

    ( pos_sw, pos_ne )

or

    pos_sw, pos_ne

### Note

- If the latitude of the southwest edge is larger than the latitude of the northeast edge, pgSphere swaps the edges.

- If the longitude of the southwest edge is equal to the longitude of the northeast edge, pgSphere assumes a full latitude range, except that the latitudes are equal, too.

Example 3.12. Input of a full latitude range

A full latitude range between +20° and +23°.

    sql> SELECT sbox '( (0d,20d), (0d,23d) )';

Example 3.13. A simple coordinates range

A coordinate range between -10° and +10° in latitude and 350° and 10° in longitude.

    sql> SELECT sbox '( (350d,-10d), (10d,+10d) )';

Prev | Up | Next
3.8. Polygon | Home | 3.10. `smoc`: HEALPix Multi-Order Coverage map