Changeset 5525 for TI01-discovery


Ignore:
Timestamp:
27/07/09 16:29:51 (10 years ago)
Author:
sdonegan
Message:

Dealt with small bug

File:
1 edited

Legend:

Unmodified
Added
Removed
  • TI01-discovery/branches/ingestAutomation-upgrade/database/ingest_procedures.sql

    r5524 r5525  
    6868DROP FUNCTION update_document(original_document_id_in int, filename_in varchar(255),  
    6969        discovery_id_in varchar(255), doc_type_in text, original_document_in text,  
    70         authors text, parameters text, scope text, scn_in int,dataset_name_in text, datacentre_name_in text, metadata_update_date_in timestamp, dataset_start_date_in timestamp) CASCADE; 
     70        authors text, parameters text, scope text, scn_in int,dataset_name_in text, datacentre_name_in text, metadata_update_date_in timestamp, dataset_start_date_in timestamp, dataset_end_date_in timestamp) CASCADE; 
    7171CREATE FUNCTION update_document(original_document_id_in int, filename_in varchar(255),  
    7272        discovery_id_in varchar(255), doc_type_in text, original_document_in text,  
    73         authors text, parameters text, scope text, scn_in int,dataset_name_in text, datacentre_name_in text, metadata_update_date_in timestamp, dataset_start_date_in timestamp)  
     73        authors text, parameters text, scope text, scn_in int,dataset_name_in text, datacentre_name_in text, metadata_update_date_in timestamp, dataset_start_date_in timestamp, dataset_end_date_in timestamp)  
    7474        RETURNS VOID AS  
    7575$$ 
     
    103103                dataset_metadata_update_date = metadata_update_date_in, 
    104104                dataset_start_date_nom = dataset_start_date_in 
     105                dataset_end_date_nom = dataset_end_date_in 
    105106                        WHERE original_document_id = original_document_id_in; 
    106107     END; 
Note: See TracChangeset for help on using the changeset viewer.