Null parm to a function
От | Gordon Clarke |
---|---|
Тема | Null parm to a function |
Дата | |
Msg-id | Pine.LNX.4.10.10006132048130.27505-100000@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Null parm to a function
|
Список | pgsql-sql |
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 int2 NOT NULL, CONSTRAINT p01_test_func PRIMARY KEY(func_sun) ); This insert works as one would expect. INSERT INTO test_func(func_sun, surname, value) VALUES(1234,null,99); Now create the function that will insert rows into my table test_func. CREATE FUNCTION insert_row(int4,varchar,int2) RETURNS int4 AS 'INSERT INTO test_func(func_sun, surname, value) VALUES($1,$2,$3); SELECT 1 AS ignore;'LANGUAGE 'sql'; Now if I try to do the same thing but via my function,SELECT insert_row(1235,null,100); I get the following errorERROR: typeidTypeRelid: Invalid type - oid = 0 Why wont the function allow me to pass a 'null' parm? Cheers...Gordon ~~~~~~~~~~~~~~ 4ZzZ Brisbane's First Community FM Station ~~~~~~~~~~~~~~ The Demo Show - Supporting Australian UnsignedArtists Mon nights 6-7pm (0800-0900UTC) on 4ZzZ 102.1 FM http://www.4zzzfm.org.au/zed (RAfeed) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
В списке pgsql-sql по дате отправления: