Re: Function that returns Boolean - Mailing list pgsql-general

SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com> writes:
> create or replace function check_value( newValue IN VARCHAR,
>                     oldValue IN VARCHAR ) RETURN BOOLEAN

Should be RETURNS BOOLEAN.

You might want to fix whatever client code you are using so that it
shows the error cursor, which would certainly have helped direct
your attention to the right place instead of the wrong one.  What
I see in psql is

ERROR:  syntax error at or near "RETURN"
LINE 2:                     oldValue IN VARCHAR ) RETURN BOOLEAN
                                                  ^


            regards, tom lane