[OpenLayers-Users] PostGis Functions on Stored Procedure

[David Calle]

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???
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20080804/110449bf/attachment.html