Re: Geometric data type for an arc. - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Geometric data type for an arc.
Date
Msg-id CAHyXU0xBaU9sU8BqVSh3zJqq5U-A=2gjhn_6+5t+TK6p8d9pKg@mail.gmail.com
Whole thread Raw
In response to Re: Geometric data type for an arc.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Thu, May 10, 2012 at 11:59 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
>> On Thu, May 10, 2012 at 10:10 AM, John W. Kitz <John.Kitz@xs4all.nl> wrote:
>>> Does anybody know how to submit a feature request for consideration to the
>>> developers of PostgreSQL?
>
>> The support for geometric types as it stands is fairly weak -- there
>> might be some reluctance to extend them (which means more operators,
>> casts, etc) without a more general look at their issues (for example,
>> why can't you extract points out of a box type)?
>
> The first question that would be asked is whether PostGIS doesn't do
> what you want.  There's not that much enthusiasm for improving the core
> geometric types because PostGIS has covered the territory.

It doesn't -- it's pretty much a polygon based system -- and PostGIS
is a huge dependency if all you want to do is store an arc for later
extraction.  IMO, the threshold for advising PostGIS should be
manipulation and precise searching, not necessarily working with
geometric objects.

I've often wondered if the built in geometric types could be
approximated with composites and arrays -- trading an efficiency loss
for flexibility and standardization.

merlin

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Geometric data type for an arc.
Next
From: Alan Hodgson
Date:
Subject: Re: I am NOT a programmer!