Thread: BUG or feature?

BUG or feature?

From
Max Vaschenko
Date:
Hi.
Bug or feature?

CREATE FUNCTION upd (text, text) RETURNS text AS '
  BEGIN
    RETURN $1;
  END
' LANGUAGE 'plpgsql';

SELECT upd('aaa','bbb');
aaa

SELECT upd(null,'bbb');
<null>

All seems ok, but how about next ?

SELECT upd('aaa',null);
<null>


--
ó Õ×ÁÖÅÎÉÅÍ, ÷ÁÝÅÎËÏ íÁËÓÉÍ,
îÉÖÅÇÏÒÏÄÓËÉÅ ÉÎÆÏÒÍÁÃÉÏÎÎÙÅ ÓÅÔÉ
(8312) 30-19-05, 34-00-02, 30-09-73

With best regards, Max Vaschenko,
Nizhny Novgorod Information Networks.

Re: BUG or feature?

From
Tom Lane
Date:
Max Vaschenko <max@nino.ru> writes:
> All seems ok, but how about next ?
> SELECT upd('aaa',null);
> <null>

This is fixed in 7.1.  It's unfixable in prior releases because the
old function manager only maintained one argument-is-null flag for a
function call ... so *all* the arguments are taken as null if any are.

            regards, tom lane