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

From Bruce Momjian
Subject Re: [SQL] line datatype
Date
Msg-id 200207161538.g6GFcS925954@candle.pha.pa.us
Whole thread Raw
In response to Re: [SQL] line datatype  (Thomas Lockhart <lockhart@fourpalms.org>)
List pgsql-hackers
Thomas Lockhart wrote:
> ...
> > > We do need a solution for exact dump/reload of floating-point data,
> > > but I don't see why the lack of it should be reason to disable access
> > > to the LINE type.
> > I don't understand why dumping the two point values isn't sufficient.
> 
> Which two point values? LINE is handled as an equation, not as points,
> unlike the LSEG type which has two points.

Well, the \dT documentation used to show line as two points, so I
assumed that was how it was specified.

> One possibility is to have the external representation *be* the same as
> LSEG, then convert internally. Then we need to decide how to scale those
> points; maybe always using a unit vector is the right thing to do...

No one likes entering an equation.  Two points seems the simplest.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [SQL] line datatype
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] CLUSTER not lose indexes