Karim Nassar <[EMAIL PROTECTED]> 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
I am writing functions and I find it curious that CREATE FUNCTION does
not do syntax checking.
Example:
test=# CREATE FUNCTION foo(INTEGER) RETURNS BOOLEAN
test-# AS 'this is total crap' LANGUAGE plpgsql;
CREATE FUNCTION
test=# select foo(1);
ERROR: syntax error at or near "this"
CONTEXT: com