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

[Maria Arias de Reyna]

El Friday 14 May 2010, rakesh modi escribió:
> 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.

I usually prefer to use ST_length instead of length. Maybe that's the problem?


(Btw, are you sure you have postgis installed on that database?)

-- 
María Arias de Reyna Domínguez
Área de Operaciones

Emergya Consultoría 
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73 
www.emergya.es