Changeset 8

Timestamp:

08/16/08 18:51:31 (4 years ago)

Author:

fumanchu

Message:

Added IMMUTABLE declarations and tweaked some docs.

Files:

• trunk/epic/epic.sql (modified) (13 diffs)

trunk/epic/epic.sql

@@ -102 +102 @@
     * test.assert_less_than(elem_1 anyelement, elem_2 anyelement)
     * test.assert_less_than_or_equal(elem_1 anyelement, elem_2 anyelement)
-    * test.assert_values(column text, source text, expected anyarray):
+    * test.assert_values(source text, expected anyarray, colname text):
         Raises an exception if SELECT column FROM source != expected.
     
@@ -314 +314 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -329 +329 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -342 +342 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -358 +358 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -374 +374 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -390 +390 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -406 +406 @@
   END IF;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
 CREATE OR REPLACE FUNCTION test.assert_raises(call text, errm text, state text) RETURNS VOID AS $$
--- Raises an exception if 'SELECT * FROM [call];' does not raise errm.
+-- Raises an exception if 'SELECT * FROM [call];' does not raise errm and/or state.
 -- 
 -- Example:
@@ -439 +439 @@
 
 CREATE OR REPLACE FUNCTION test.assert_raises(call text, errm text) RETURNS VOID AS $$
--- Implicit column version of assert_values
+-- Implicit state version of assert_raises
 BEGIN
   PERFORM test.assert_raises(call, errm, NULL);
@@ -446 +446 @@
 
 CREATE OR REPLACE FUNCTION test.assert_raises(call text) RETURNS VOID AS $$
--- Implicit errm, column version of assert_values
+-- Implicit errm, column version of assert_raises
 BEGIN
   PERFORM test.assert_raises(call, NULL, NULL);
@@ -487 +487 @@
   RETURN;
 END;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE plpgsql IMMUTABLE;
 
 
@@ -493 +493 @@
 -- Raises an exception if SELECT column FROM source != expected.
 --
--- colname shoudl be the name of the column in source to compare.
+-- colname should be the name of the column in source to compare.
 -- If NULL, it will be taken from the first column of source's output.
 --
 -- source can be any table, view, or procedure that returns records.
+-- 
 -- expected MUST be an array of the same type as colname.
 -- Neither source nor expected need to be sorted.
@@ -561 +562 @@
 $$ LANGUAGE plpgsql;
 
-
 CREATE OR REPLACE FUNCTION test.assert_values(source text, expected anyarray) RETURNS VOID AS $$
 -- Implicit column version of assert_values