diff options
Diffstat (limited to 'sql/Pg-functions.sql')
-rwxr-xr-x | sql/Pg-functions.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/sql/Pg-functions.sql b/sql/Pg-functions.sql index ee70b0e7..c11def4d 100755 --- a/sql/Pg-functions.sql +++ b/sql/Pg-functions.sql @@ -249,15 +249,13 @@ BEGIN RETURN v_cost; END; -' language 'plpgsql'; +' language plpgsql; -- end function -- -CREATE OR REPLACE FUNCTION trigger_parts_short() RETURNS TRIGGER -AS -' CREATE OR REPLACE FUNCTION trigger_parts_short() RETURNS TRIGGER AS +' BEGIN IF NEW.onhand >= NEW.rop THEN NOTIFY parts_short; |