Project

General

Profile

« Previous | Next » 

Revision 175

Added by bojilova over 24 years ago

db trigger xml_nodes_before_insert no longer in use

View differences:

src/xmltables.sql
55 55 

  		




  56
  56
  
    
CREATE SEQUENCE xml_nodes_id_seq;


  		




  57
  57
  
    

  		




  58
  
  
    
CREATE TRIGGER xml_nodes_before_insert


  		




  59
  
  
    
BEFORE INSERT ON xml_nodes FOR EACH ROW


  		




  60
  
  
    
BEGIN


  		




  61
  
  
    
  SELECT xml_nodes_id_seq.nextval


  		




  62
  
  
    
    INTO :new.nodeid


  		




  63
  
  
    
    FROM dual;


  		




  64
  
  
    
END;


  		




  65
  
  
    
/


  		




  66
  
  
    

  		




  67
  58
  
    
/* 


  		




  68
  59
  
    
 * Documents -- table to store XML documents


  		




  69
  60
  
    
 */


  		












Also available in:  Unified diff