14. Summary


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.


Click the Next exercise button to continue.