Can I use in a postgis db within the same table a combination of CRS?

المشرف العام

Administrator
طاقم الإدارة
I'm experimenting around with my postgis2.0 database. I want to create a basic table to store all my point data and in the process,I realized that the coordinates are in different CRSs. So naturally I'm wondering now if the the_geom column can contain a variety of CRSs - or Im confined to a single CRS per table.

To visualize it a bit, Is the following possible?

point_id | the_geom |1 | (geom_string1)
 
أعلى