Re: [INTERFACES] Function's final statement must be a SELECT

Tried that already, still the same error

On Wed, May 14, 2008 at 4:36 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> On Wed, May 14, 2008 at 9:23 PM, Premil Agarwal <preagarw(at)gmail(dot)com>
> wrote:
> > 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 ??
>
> Choose pl/pgsql as the language, not SQL.
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>