Re: [SQL] line datatype - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [SQL] line datatype
Date
Msg-id 3D33B8D5.D8A2E1CE@fourpalms.org
Whole thread Raw
In response to Re: [SQL] line datatype  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [SQL] line datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> It would be nice to get the line type working 100%.  Thomas says the
> problem is input/output format.  I don't completely understand.

The issue is in choosing an external format for LINE which does not lose
precision during dump/reload. Internally, LINE is described by a formula
which is likely subject to problems with limited precision for some line
orientations.

Does anyone have a suggestion (perhaps drawn from another GIS package)
for representing lines? We already have this implemented internally, and
the algorithms are used to support other data types; the only unresolved
issue is in how to input the values.
                  - Thomas


pgsql-hackers by date:

Previous
From: Curt Sampson
Date:
Subject: Re: [PATCHES] CLUSTER not lose indexes
Next
From: Thomas Lockhart
Date:
Subject: Re: bit type external representation