Re: ERROR: control reached end of function without RETURN

From: "Ignacio Colmenero" <ignacio(dot)colmenero(at)micotan(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: control reached end of function without RETURN
Date: 2005-02-11 19:49:13
Message-ID: 20050211194917.VJHS289.priv-edtnes46.telusplanet.net@ignacio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Tom.
I didn't know I needed a RETURN statement at the end. I assumed that the
"return next" statement would be enough. It works fine now.

-----------------------------------------------
Ignacio Colmenero
Software Development
Micotan Software Company Ltd.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: February 11, 2005 12:28 PM
To: Ignacio Colmenero
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] ERROR: control reached end of function without RETURN

"Ignacio Colmenero" <ignacio(dot)colmenero(at)micotan(dot)com> 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: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

In response to

Browse pgsql-general by date

  From Date Subject
Next Message benjamin jacob 2005-02-11 20:16:50 data duplication
Previous Message Tom Lane 2005-02-11 19:32:31 Re: test datatype for ANY