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
Ignacio Colmenero [EMAIL PROTECTED] writes:
I get the error: ERROR: control reached end of function without RETURN
What can be wrong?
You don't have a RETURN statement.
regards, tom lane
---(end of broadcast)---
TIP 5:
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: February 11, 2005 12:28 PM
To: Ignacio Colmenero
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ERROR: control reached end of function without RETURN
Ignacio Colmenero [EMAIL PROTECTED] writes:
I get the error: ERROR