Re: [SQL] line datatype

Поиск
Список
Период
Сортировка
От Tim Hart
Тема Re: [SQL] line datatype
Дата
Msg-id 3473695.1026835234816.JavaMail.tjhart@mac.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] CLUSTER not lose indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_views.definition