Re: simple coordinate system

On Fri, Mar 16, 2007 at 15:55:15 +0100,
Robin Ericsson <lobbin(at)gmail(dot)com> wrote:
> On 3/16/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >"Robin Ericsson" <lobbin(at)gmail(dot)com> 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.