On Fri, Mar 16, 2007 at 15:55:15 +0100, Robin Ericsson <lobbin@xxxxxxxxx> wrote: > On 3/16/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > >"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. > > My hope was that there was something between standard PostgreSQL and > PostGIS as I didn't want to bring in the whole PostGIS into my > application. But probably it's worth it anyways. The cube contrib stuff might be useful for you.
