Project

General

Profile

« Previous | Next » 

Revision 6358

schemas/functions.sql: _nullIf(): Removed NOT NULL constraint on null param, to support use a (nullable) column rather than a literal as the null-equivalent value

View differences:

schemas/functions.sql
310 310
    LANGUAGE plpgsql IMMUTABLE
311 311
    AS $$
312 312
DECLARE
313
    "null" text NOT NULL := "null"; -- add NOT NULL
314 313
    type functions.datatype NOT NULL := type; -- add NOT NULL
315 314
BEGIN
316 315
    IF type = 'str' THEN RETURN nullif(value::text, "null");

Also available in: Unified diff