[postgis-users] HINT: No function matches the given name and argument types

[Emilie Laffray]

On 14 May 2010 10:21, rakesh modi <rakesh.modi1585 at gmail.com> wrote:

> hi,
> 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.

Emilie Laffray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100514/0fdb3032/attachment.html>