In this article, the author discusses calculating distances in projected and spherical coordinate systems in respect of geometry and geographic data using PostGIS functions.