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 "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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
