Astronomical coordinates utilities
Maintainer(s):
teobouvard
Installing and Loading
INSTALL celestial FROM community;
LOAD celestial;
Example
SELECT spherical_angle(0, 0, 1, 0) AS radians_along_equator;
About celestial
The celestial extension provides functions for working with astronomical coordinates.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| spherical_angle | scalar | Compute the angle between two points on the sphere | Input coordinates in radians (RA_1, DEC_1, RA2, DEC_2). Output angle in radians. | [SELECT spherical_angle(0, 0, 1, 0);] |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases | |——|————-|————|——-|———|