summaryrefslogtreecommitdiff
path: root/sql/Pg-functions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/Pg-functions.sql')
-rwxr-xr-xsql/Pg-functions.sql6
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;