From 0312a7244ef5a76954822e4192f34c5da6e21f95 Mon Sep 17 00:00:00 2001
From: Christopher Browne <cbbrowne@ca.afilias.info>
Date: Wed, 3 Jul 2013 12:30:26 -0400
Subject: [PATCH] Add in a sample function using named parameters; this has
 been not working properly in some recent versions

---
 regressdatabase.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/regressdatabase.sql b/regressdatabase.sql
index 80f31b9..b0bf0b2 100644
--- a/regressdatabase.sql
+++ b/regressdatabase.sql
@@ -112,6 +112,14 @@ COMMENT ON FUNCTION product.worker(integer, integer) IS
 COMMENT ON FUNCTION warehouse.worker(integer, integer) IS
 'Worker function appropriate for warehouses.';
 
+create or replace function product.worker2 (i_1 integer, i_2 integer) returns integer as $$
+begin
+   return i_1 + i_2;
+end
+$$ language plpgsql;
+
+comment on function product.worker2 (i_1 integer, i_2 integer) 
+is 'worker function that uses named parameters';
 
 --
 -- Inheritance
-- 
2.50.1