Re: [SQL] Null parm to a function

2000-06-16 Thread Tom Lane
Gordon Clarke <[EMAIL PROTECTED]> writes: > Now if I try to do the same thing but via my function, > SELECT insert_row(1235,null,100); > I get the following error > ERROR: typeidTypeRelid: Invalid type - oid = 0 > Why wont the function allow me to pass a 'null' parm? You're running

[SQL] Null parm to a function

2000-06-16 Thread Gordon Clarke
I want to be able to pass NULL as a parameter to a function I've defined, but I'm not allowed to do it. I believe this is a bug. The example follows: CREATE TABLE test_func( func_sun int4, surname varchar(30), value int2NOT NULL, CONS