On Dec 4, 2007 6:04 PM, Peck, Brian <[EMAIL PROTECTED]> wrote:
> SELECT source_id as vertex INTO result FROM $3 ORDER BY
> Distance(the_geom,PointFromText(POINT( $1 $2 ))) LIMIT 1;
I think you're missing a comma, e.g. POINT( $1 , $2 ).
---(end of broadcast)---
Hey all,
I'm trying to create functions for the calls I'm making to limit the
number of DB pings I have to make (i.e. after they are all calls make
one call that calls them in succession) and I'm getting an error.
The function is
CREATE OR REPLACE FUNCTION nearestVertex(x1 double preci