Show birthdays in menu

[ndwebbie.git] / database / birthday.sql

diff --git a/database/birthday.sql b/database/birthday.sql
index 65c5a861a22179c0f0bca5ea40f2ed50ba401c51..33b2b1e9fb46eb111db4a91f0ff8cddbf6d45ac0 100644 (file)
--- a/database/birthday.sql
+++ b/database/birthday.sql
@@ -1 +1,5 @@
 ALTER TABLE users ADD birthday DATE;
+
+CREATE FUNCTION mmdd(d date) RETURNS text AS $SQL$ SELECT to_char($1,'MM-DD') $SQL$ LANGUAGE SQL IMMUTABLE;
+
+CREATE INDEX users_birthday_index ON users (mmdd(birthday)) WHERE birthday IS NOT NULL;