On Wed, May 14, 2008 at 9:23 PM, Premil Agarwal <[EMAIL PROTECTED]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
