Project

General

Profile

« Previous | Next » 

Revision 2864

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/functions.sql: _nullIf: Require a non-NULL null-equivalent value

View differences:

schemas/functions.sql
227 227 
CREATE TABLE "_nullIf" (
228 228 
    result text,
229 229 
    not_null_col boolean DEFAULT true NOT NULL,
230 
    "null" text,
230 
    "null" text NOT NULL,
231 231 
    type datatype DEFAULT 'str'::datatype NOT NULL,
232 232 
    value text
233 233 
);
......
426 426 
-- Name: _nullIf_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace:
427 427 
--
428 428 

  		




  429
  
  
    
CREATE UNIQUE INDEX "_nullIf_unique" ON "_nullIf" USING btree (ensure_not_null("null"), type, ensure_not_null(value));


  		




  
  429
  
    
CREATE UNIQUE INDEX "_nullIf_unique" ON "_nullIf" USING btree ("null", type, ensure_not_null(value));


  		




  430
  430
  
    

  		




  431
  431
  
    

  		




  432
  432
  
    
--


  		












Also available in:  Unified diff