[postgis-users] Adding Spatial Index to Existing Table

[Adam]

This is my first try at adding spatial to my table.  Currently I have a 'Lat' and 'Long' columns that have my Latitiude and Longitude.

Do I need to add another column named 'Location' and insert each rows 'Lat' and 'Long' into the corresponding 'Location' row by doing:  "INSERT INTO table ( Location ) VALUES ( GeometryFromText('Point xx.xxx yy.yyyy', 4326) )" ?  This will assume WGS 84 datum.

Is this right?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061229/4ebeae2d/attachment.html>