On Friday 28 November 2008 15:31:51 Barry Sanford wrote:
> looking at PostgreSQL, I noticed that you have various geometric data types
> as standard. However, I was somewhat surprised that you are attempting to
> implement the 'line' type via a two point scheme. While this is okay for
> line segments, it totally sucks for infinite lines in a plane or space.
Well, it's the way Euclid defined it. (Yes, PostgreSQL is really
old ... ;-) )
No really, the built-in geometry types are considered kind of legacy. If you
want to deal with something more modern, you may want to look into PostGIS.