Karim Nassar <Karim(dot)Nassar(at)NAU(dot)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