Project

General

Profile

« Previous | Next » 

Revision 6358

Added by Aaron Marcuse-Kubitza over 11 years ago

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:

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