From 73fb0214764d0b484dad31e300665d74abfc61e6 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@semantico.com>
Date: Tue, 21 Jun 2016 16:39:00 +0100
Subject: [PATCH] psql dump

---
 lib/postgres/functions.sql | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/lib/postgres/functions.sql b/lib/postgres/functions.sql
index 3dec9b36..d97c3ffb 100644
--- a/lib/postgres/functions.sql
+++ b/lib/postgres/functions.sql
@@ -14,6 +14,12 @@ CREATE AGGREGATE CONCAT(
 
 );
 
+DROP FUNCTION IF EXISTS DATE(sdate text, sinterval text);
+CREATE OR REPLACE FUNCTION DATE(sdate text DEFAULT 'now', sinterval text DEFAULT '0 seconds')
+RETURNS text AS $$
+SELECT to_char(sdate::date + sinterval::interval,'YYYY-MM-DD');
+$$ LANGUAGE sql;
+
 CREATE OR REPLACE FUNCTION GROUP_CONCAT(anyarray, sep text DEFAULT ',', nullstr text DEFAULT '')
 RETURNS text AS $$
 SELECT array_to_string( ARRAY( SELECT coalesce(v::text, $3) FROM unnest($1) g(v) ), $2 )
-- 
2.47.3