← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/PostGres/Install/Functions/products.UserDefinedFunction.sql

  • Committer: sk
  • Date: 2011-09-10 05:32:36 UTC
  • Revision ID: halega@halega.com-20110910053236-1877r3p0k4a64bgx
Tags: 1.2.2
1.2.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
SQLInstaller.Sample/Scripts/PostGres/Install/Functions/products.UserDefinedFunction.sql
 
1
CREATE OR REPLACE FUNCTION products() RETURNS TRIGGER AS '
 
2
BEGIN
 
3
        IF TG_OP = ''UPDATE'' THEN 
 
4
                IF NEW.unitsinstock < 0 THEN
 
5
                        NEW.unitsonorder := NEW.unitsonorder - NEW.unitsinstock;
 
6
                        NEW.unitsinstock := 0;
 
7
                ELSIF (NEW.unitsinstock < NEW.reorderlevel AND NEW.unitsonorder = 0) THEN
 
8
                        NEW.unitsonorder = NEW.reorderlevel;
 
9
                END IF;
 
10
        END IF;
 
11
 
 
12
        IF TG_OP = ''DELETE'' THEN
 
13
                RETURN OLD;
 
14
        ELSE
 
15
                RETURN NEW;
 
16
        END IF;
 
17
END;
 
18
'  LANGUAGE 'plpgsql';