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

From Tim Hart
Subject Re: [SQL] line datatype
Date
Msg-id 3473695.1026835234816.JavaMail.tjhart@mac.com
Whole thread Raw
List pgsql-hackers
Actually... as one with the vested interest...

I'm not opposed to entering an equation in one of the basic algebraic forms. Given that line types and line segment
typesboth exist, I'm happy to weigh the cost/benefit between choosing an lseg and entering 2 points, or choosing a line
andentering the equation.
 

Are there database functions to translate between a line and a line seg? If so, that would address my only reservation
forrestricting the line type to an equation. And - to address Tom's continuing concern over casting ;), I have no need
forimplicit casts in this case.
 

If there are concerns about precision being lost in the translation - As long as what precision can be guaranteed is
documented,I have no qualms. If I needed absolute precision I'd create my own line table with numerics, and write my
ownfunctions as necessary. The line type to me is there for speed and ease of use, not unlimited precision.
 

On Tuesday,  16, 2002, at 09:38AM, Bruce Momjian <pgman@candle.pha.pa.us> wrote:

>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, Pennsylvania 19026
>
>



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] CLUSTER not lose indexes
Next
From: Tom Lane
Date:
Subject: Re: pg_views.definition