From: Premil Agarwal <preagarw@gmail.com>
To: pgsql-interfaces@postgresql.org
To: pgsql-admin@postgresql.org
Subject: Function's final statement must be a SELECT
Date: Wed, 14 May 2008 16:23:33 -0400
Message-ID: <92aa956e0805141323y3c14fe2p4e10ba9c67637c49@mail.gmail.com> (raw)
I am trying to write a function in PgAdmin 1.8.2 for postgres 8.3. The
function should check the input parameter for NULL. If its NULL then
function should return 'Auto' otherwise return the input as such.
CREATE FUNCTION check_for_null( inp character varying) RETURNS character
varying AS $$
DECLARE
temp1 character varying := 'Auto';
temp2 character varying := inp;
BEGIN
IF temp2 IS NOT NULL THEN
temp1 := temp2;
END IF;
RETURN temp1;
END;
$$ LANGUAGE SQL;
When I hit 'OK' in create function window, I get following error :-
ERROR: return type mismatch in function declared to return *character
varying
DETAIL*: Function's *final statement must be a SELECT*.
CONTEXT: SQL function "check_for_null"
Any suggestions why this happens ??
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: preagarw@gmail.com, pgsql-admin@postgresql.org
Subject: Re: Function's final statement must be a SELECT
In-Reply-To: <92aa956e0805141323y3c14fe2p4e10ba9c67637c49@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox