X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fbirthday.sql;h=33b2b1e9fb46eb111db4a91f0ff8cddbf6d45ac0;hp=65c5a861a22179c0f0bca5ea40f2ed50ba401c51;hb=48c13dfb589d4f8f83d8fdc2df772c32d4145659;hpb=15e271f8e65bfc35d311f9b9cad581e3a1c70def

diff --git a/database/birthday.sql b/database/birthday.sql
index 65c5a86..33b2b1e 100644
--- 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;