Re: Function syntax checking

Karim Nassar <Karim.Nassar@NAU.EDU> writes:
> I am writing functions and I find it curious that CREATE FUNCTION does
> not do syntax checking.

Try 8.0 ;-)

regression=# CREATE FUNCTION foo(INTEGER) RETURNS BOOLEAN
regression-# AS 'this is total crap' LANGUAGE plpgsql;
ERROR:  syntax error at or near "this" at character 50
LINE 2: AS 'this is total crap' LANGUAGE plpgsql;
            ^

We could be doing more along this line, but it's a start ...

            regards, tom lane