Introduction
Summary
14. Summary

Instruction

Good job! It's time to wrap things up for this part of the course.

  • Geometry columns are quick, but they may produce incorrect results for large areas. They always require you to specify an SRID.
  • Geography columns are slow, but very accurate. They do not require SRIDs. Geography columns are essential when working with big areas, such as countries or continents.
  • Not all of the functions we learned can perform geography calculations or accept geography columns. If a function requires a geometry type, you can cast a geography column by appending ::geometry to its name.

Awesome! We'll now present a short quiz on the concepts you learned in this part of the course.

Exercise

Click the Next exercise button to continue.

Console

Code editor

Result

TableConsole