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.