Re: [GENERAL] Function syntax checking

2004-10-24 Thread Tom Lane
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

[GENERAL] Function syntax checking

2004-10-24 Thread Karim Nassar
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