Hi List,
I'm trying to use the Distance Function in a Declared Fuction but I have
this error:
CREATE FUNCTION consul1ta_parametros(float, float) RETURNS void AS '
x_pos ALIAS FOR $1;
y_pos ALIAS FOR $2;
select distance(
the_geom,
PointFromText('POINT( '|| x_pos || ' ' || y_pos ||' )', 24877)
)
from recorrido where estado = 'V'' LANGUAGE SQL;
ERROR: syntax error at or near "POINT" en el carácter 157
The question is... Can I use the PostGIS functions here???
_______________________________________________
Users mailing list
[email protected]
http://openlayers.org/mailman/listinfo/users
