Re: [GENERAL] simple coordinate system

2007-04-06 Thread Bruno Wolff III
On Fri, Mar 16, 2007 at 15:55:15 +0100, Robin Ericsson [EMAIL PROTECTED] wrote: On 3/16/07, Tom Lane [EMAIL PROTECTED] wrote: Robin Ericsson [EMAIL PROTECTED] 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

Re: [GENERAL] simple coordinate system

2007-03-16 Thread Robin Ericsson
On 3/15/07, Webb Sprague [EMAIL PROTECTED] wrote: http://www.postgresql.org/docs/8.2/static/datatype-geometric.html Have you looked at these yet? If not, you asked your question prematurely and should have read the docs. If so, in what respect do they not work for you? Yes, I've looked at

Re: [GENERAL] simple coordinate system

2007-03-16 Thread Tom Lane
Robin Ericsson [EMAIL PROTECTED] 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 ---

Re: [GENERAL] simple coordinate system

2007-03-16 Thread Robin Ericsson
On 3/16/07, Tom Lane [EMAIL PROTECTED] wrote: Robin Ericsson [EMAIL PROTECTED] 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.

[GENERAL] simple coordinate system

2007-03-15 Thread Robin Ericsson
Hi, I'm planning a simple coordinate system, where objects are described as x, y and z. Are there any contribs or extensions available that can help me with datatypes, calculation of length between two points, etc? -- regards, Robin ---(end of

Re: [GENERAL] simple coordinate system

2007-03-15 Thread Webb Sprague
... planning a simple coordinate system, where objects are described as x, y and z. Are there any contribs or extensions available that can help me with datatypes, calculation of length between two points, etc? google postgis. It is for geographic stuff, so maybe overkill, but maybe not.

Re: [GENERAL] simple coordinate system

2007-03-15 Thread Robin Ericsson
On 3/15/07, Webb Sprague [EMAIL PROTECTED] wrote: ... planning a simple coordinate system, where objects are described as x, y and z. Are there any contribs or extensions available that can help me with datatypes, calculation of length between two points, etc? google postgis. It is for

Re: [GENERAL] simple coordinate system

2007-03-15 Thread Webb Sprague
http://www.postgresql.org/docs/8.2/static/datatype-geometric.html Have you looked at these yet? If not, you asked your question prematurely and should have read the docs. If so, in what respect do they not work for you? On 3/15/07, Robin Ericsson [EMAIL PROTECTED] wrote: On 3/15/07, Webb