[postgis-users] Conversion from undefined geometry to geography?

[Nicholas Bower]

We have some tables in which we've used Geometry to store polygon and point
lan/lon (srid = -1).  We embarked on this before PostGIS 1.5.x's spherical
Geography objects.

Now we intend to upgrade and migrate these to new Geography types (eg new
geography col, copy/convert, drop original geometry col).

Is there an existing function that provides a conversion from Geometry to
Geography that could be used in a simple table update?  This doesn't give
away too many clues what will happen when given a geometry with srid = -1
for example:

http://postgis.refractions.net/docs/geography.html

TIA.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100414/9b27ffe8/attachment.html>