Re: Points, Circles, Indexes, and query-by-Radius?

> > For extra credit, it would be nice if I could store circles instead of
> > points, and issue queries like the following:
> >
> > "given a circle ((X,Y),R), return all circles which share some common area"
> >
>
> I haven't yet played with it, but look at PostGIS, an add-on for
> PostgreSQL which claims to have better spatial indexing & querying
> capabilities for geometric datatypes.
>
> As an aside, can anyone comment on the likelihood of this becoming a part
> of mainstream pgsql? Or what is currently happening with pgsql spatial
> support, especially regarding fmaps development?

PostGIS is sitting in my mailbox and I am waiting to hear if it should
be added to contrib. It is 132k.

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