1 files changed, 15 insertions, 0 deletions
diff --git a/sql/modules/Defaults.sql b/sql/modules/Defaults.sql
new file mode 100644
index 00000000..62597faf
--- /dev/null
+++ b/sql/modules/Defaults.sql
@@ -0,0 +1,15 @@
+-- Probably want to move this to the Settings module
+
+CREATE OR REPLACE FUNCTION defaults_get_defaultcurrency() 
+RETURNS SETOF char(3) AS
+$$
+DECLARE defaultcurrency defaults.value%TYPE;
+      BEGIN   
+           SELECT INTO defaultcurrency substr(value,1,3)
+           FROM defaults
+           WHERE setting_key = 'curr';
+           RETURN NEXT defaultcurrency;
+      END;
+$$ language plpgsql;                                                                  
+COMMENT ON FUNCTION defaults_get_defaultcurrency() IS
+$$ This function return the default currency asigned by the program. $$;