FW: [postgis-users] About Invalid OGC WKT Error

[Kralidis,Tom [Burlington]]

I get this:

$ /usr/local/pgsql/bin/psql -f ./t.sql -d thedb -U scott
psql:./t.sql: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.

..Tom






-----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') )


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