Re: [GENERAL] Create function errors

2007-12-04 Thread Rodrigo De León
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)---

[GENERAL] Create function errors

2007-12-04 Thread Peck, Brian
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