[postgis-users] HINT: No function matches the given name and argument types
emilie.laffray at gmail.com
Fri May 14 02:39:14 PDT 2010
On 14 May 2010 10:21, rakesh modi <rakesh.modi1585 at gmail.com> wrote:
> i am using select query which is shown below
> SELECT sum(length(the_geom))/1000 AS km_roads FROM routable;
> and get error like -
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
what is the projection of your geometry? ST_Length returns a length in the
unit of the chosen projection. If you are working with lat, lon, you won't
have meters coming out of ST_Length.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users