From: | Gordon Clarke <gordonc(at)acenet(dot)net(dot)au> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Null parm to a function |
Date: | 2000-06-17 05:15:36 |
Message-ID: | Pine.LNX.4.10.10006132048130.27505-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 error
ERROR: 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 Unsigned Artists
Mon nights 6-7pm (0800-0900UTC) on 4ZzZ 102.1 FM
http://www.4zzzfm.org.au/zed (RA feed)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-17 05:46:01 | Re: Null parm to a function |
Previous Message | Joseph Shraibman | 2000-06-16 19:09:03 | BETWEEN |