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@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