Today I Learned

hashrocket A Hashrocket project

Assumed Radius Of The Earth In PostgreSQL

Using the earthdistance module, we can get the assumed radius of the earth (in meters).

> create extension cube;
CREATE EXTENSION

> create extension earthdistance;
CREATE EXTENSION

> select earth();
  earth
---------
 6378168
See More #sql TILs
Looking for help? Hashrocket developers believe that data quality is as important as code quality. We enjoy all the challenges of relational databases, from finding the fastest index, to structuring data to fit the needs of an application. We're eager to share our experiences; check out PG Casts, our series of free PostgreSQL screencasts.