[postgis-users] About Invalid OGC WKT Error

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Paul Ramsey
> Sent: Wednesday, 02 February, 2005 18:39
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] About Invalid OGC WKT Error
> 
> 
> What happens when you plug the query into psql?
> 
> SELECT 
> astext(force_collection(force_2d(the_geom)),'NDR'),OID::text 
> from service_endpoints WHERE the_geom && 
> setSRID('BOX3D(-141.089 36.392987,-52.089 89.784987)'::BOX3D,
> find_srid('','service_endpoints','the_geom') )
>

I get this output:

[postgres at devgeo postgres]$ psql -f
/usr/local/wwwsites/apache/devgeo.cciw.ca/apps/mapserv/services/eccat/te
st.sql -d devgeodb

psql:/usr/local/wwwsites/apache/devgeo.cciw.ca/apps/mapserv/services/ecc
at/sss:1: ERROR:  function astext(geometry, "unknown") does not exist
HINT:  No function matches the given name and argument types. You may
need to add explicit type casts.
[postgres at devgeo postgres]$
 
> 
> Kralidis,Tom [Burlington] wrote:
> 
> > [Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] 
> > query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT 
> > asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from 
> > service_endpoints WHERE the_geom && setSRID('BOX3D(-141.089 
> > 36.392987,-52.089 89.784987)'::BOX3D,
> > find_srid('','service_endpoints','the_geom') )
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>