----- "SHARMILA JOTHIRAJAH" <sharmi_jo@xxxxxxxxx> wrote:
> Hi,
> This is a simple function that returns a boolean ..
>
> create or replace function check_value( newValue IN VARCHAR,
> oldValue IN VARCHAR ) RETURN BOOLEAN
^^^^^^ RETURNS
> 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
>
>
Adrian Klaver
aklaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
