[postgis-users] help with pgsql2shp error

[strk]

On Fri, Nov 05, 2010 at 09:43:14PM -0400, Sam Snellings wrote:
> select count(asEWKB(the_geom)) from global_points;
> 
> Returns the following error:
> 
> ERROR: function asewkb(geography) does not exist

Try asewkb(the_geom::geometry)

> asEWKB(), ST_isValid() and ST_isValidReason() don't work with geography data types,
> correct?

You can cast geography to geometry using the ::geometry operator.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html