btree (lat_radians);
CREATE INDEX long_radians ON test_zip_assoc USING btree
(long_radians);
Maybe I'm missing something, but wouldn't it be easier to just use
PostGIS? Or failing that, using the vanilla built-in point type and an
r-tree index? That's what r-tree indexes are made
in a machine, it quite
another thing to know how much the user wants dedicated to PostgreSQL.
A couple of questions like that can go a long way to coming up with
better ballpark figures.
--
Jeff Hoffmann
[EMAIL PROTECTED]
---(end of broadcast)-
