tests/phpunit/data/db/postgres/functions.sql

   1 -- Postgres test file for DatabaseTest::testStoredFunctions()
   2
   3 CREATE FUNCTION mw_test_function()
   4 RETURNS INTEGER
   5 LANGUAGE plpgsql AS
   6 $mw$
   7 DECLARE foo INTEGER;
   8 BEGIN
   9         foo := 21;
  10         RETURN foo * 2;
  11 END
  12 $mw$;