X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Ffunctions%2Findex.sql;fp=database%2Ffunctions%2Findex.sql;h=115a65c1bc16ad59dd44e75fcb3bce4f3c2d616e;hb=76887e53c27118fe04ae8fe75dce610a398b5853;hp=0000000000000000000000000000000000000000;hpb=73119e806350719e2ce899bfbaa2ba19f0dc87d1;p=ndwebbie.git

diff --git a/database/functions/index.sql b/database/functions/index.sql
new file mode 100644
index 0000000..115a65c
--- /dev/null
+++ b/database/functions/index.sql
@@ -0,0 +1,2 @@
+CREATE FUNCTION mmdd(d date) RETURNS text AS $SQL$ SELECT to_char($1,'MM-DD') $SQL$ LANGUAGE SQL IMMUTABLE;
+