SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 07:33 PM
| ||||
| ||||
 ERROR: control reached end of function without RETURN Hi all. I created a function, using EMS: CREATE OR REPLACE FUNCTION "geo_schema"."search_geo" () RETURNS SETOF varchar AS $body$ declare x_longlat cursor for select long_lat from h2s ; declare var_longlat public.geometry ; declare x_id varchar ; begin open x_longlat ; <<loop1>> loop fetch x_longlat into var_longlat ; if not found then close x_longlat ; exit ; end if ; select field_id from geo_table where within(var_longlat, geo_polygon) limit 1 into x_id ; if x_id <> '' then return next x_id ; end if ; end loop ; end ; $body$ LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER; When I debug it (using EMS tools), it works fine, and I get 73 rows, but when I run it like: select * from search_geo() ; I get the error: ERROR: control reached end of function without RETURN What can be wrong? TIA Ignacio. ----------------------------------------------- Ignacio Colmenero Software Development Micotan Software Company Ltd.      |
Linear Mode
