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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users