[GENERAL] Function that returns Boolean

[SHARMILA JOTHIRAJAH]

Hi,
This is a simple function that returns a boolean ..

create or replace function check_value( newValue IN VARCHAR,
                    oldValue IN VARCHAR ) RETURN BOOLEAN
as
'
BEGIN
    IF ( newValue != oldValue)
        then return true;
    else
        return false;
     END IF;
END;
'
LANGUAGE 'plpgsql'

But I get this error...what is wrong with this ?

[Error] Script lines: 1-13 -------------------------
 ERROR: syntax error at or near "RETURN"
 Line: 2 

Thanks
Sharmila


      

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general