Create function errors

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 precision, y1 double
precision,road_network character varying) RETURNS integer AS

$$

DECLARE

result integer;

BEGIN

SELECT source_id as vertex INTO result FROM $3 ORDER BY
Distance(the_geom,PointFromText(POINT( $1 $2 ))) LIMIT 1;

RETURN result;

END;

$$

LANGUAGE plpgsql;

And the error I get is

psql:D:/LMCO/AFUO/trunk/ASDFS_ODBC_2007_08_16/Scripts/PostgreSQL/functio
ns.sql:12: ERROR: syntax error at or near "$1"

LINE 1: SELECT source_id as vertex FROM $1 ORDER BY Distance(the_g...

^

QUERY: SELECT source_id as vertex FROM $1 ORDER BY
Distance(the_geom,PointFromText(POINT( $2 $3 ))) LIMIT 1

CONTEXT: SQL statement in PL/PgSQL function "nearestvertex" near line 5

I'm having trouble troubleshooting it since it's query is not what
should be the query actually being performed.

- Brian Peck

- 858-795-1398

- Software Engineer

- Lockheed Martin