"Robin Ericsson" <lobbin@xxxxxxxxx> writes: > Yes, I've looked at those, I was thinking that point looked like a > good type, but it's only 2d, so maybe I need a hint on how to use this > in a 3d environment. Yeah, the built-in geometric types are all 2D. If you need 3D, perhaps PostGIS can help --- otherwise you're on your own :-(. But adding a new datatype to PG isn't hard, if you can hack C at all. regards, tom lane