Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA68090 for ; Sat, 25 Sep 1999 18:48:13 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id SAA12027; Sat, 25 Sep 1999 18:46:51 -0400 (EDT) To: Radek Kanovsky cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] create function(date,date,date,...) In-reply-to: Your message of Sat, 25 Sep 1999 19:51:01 +0200 (CEST) Date: Sat, 25 Sep 1999 18:46:50 -0400 Message-ID: <12025.938299610@sss.pgh.pa.us> From: Tom Lane Radek Kanovsky writes: > It happens that when some argument is NULL, than all argument get NULL. > It works correctly only when all arguments are not NULL. > How can I mix NULL and DATE values in arguments? Right now, you can't. The function-call interface inside Postgres is misdesigned (in several ways, but the one that's important here is that only one argument-is-NULL flag gets passed to the function from the expression evaluator). Fixing this is on the to-do list, and should get done for 6.6 or 6.7. regards, tom lane