Null parm to a function

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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-sql by date

  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