Re: [GENERAL] ERROR: control reached end of function without RETURN

2005-02-11 Thread Ignacio Colmenero
ssage- From: [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

Re: [GENERAL] ERROR: control reached end of function without RETURN

2005-02-11 Thread Tom Lane
"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)--- TI

[GENERAL] ERROR: control reached end of function without RETURN

2005-02-11 Thread Ignacio Colmenero
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 ; <>