aboutsummaryrefslogtreecommitdiff
path: root/contrib/datetime/datetime_functions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/datetime/datetime_functions.sql')
-rw-r--r--contrib/datetime/datetime_functions.sql75
1 files changed, 0 insertions, 75 deletions
diff --git a/contrib/datetime/datetime_functions.sql b/contrib/datetime/datetime_functions.sql
deleted file mode 100644
index 955377909a2..00000000000
--- a/contrib/datetime/datetime_functions.sql
+++ /dev/null
@@ -1,75 +0,0 @@
-func=$1
-cat <<% > datetime_functions.sql
-drop function time_difference(time,time);
-drop function currentdate();
-drop function currenttime();
-drop function hours(time);
-drop function minutes(time);
-drop function seconds(time);
-drop function day(date);
-drop function month(date);
-drop function year(date);
-drop function asminutes(time);
-drop function asseconds(time);
-drop operator - (time,time);
-
-create function time_difference(time,time)
- returns time
- as '$func'
- language 'c';
-
-create function currentdate()
- returns date
- as '$func'
- language 'c';
-
-create function currenttime()
- returns time
- as '$func'
- language 'c';
-
-create function hours(time)
- returns int4
- as '$func'
- language 'c';
-
-create function minutes(time)
- returns int4
- as '$func'
- language 'c';
-
-create function seconds(time)
- returns int4
- as '$func'
- language 'c';
-
-create function day(date)
- returns int4
- as '$func'
- language 'c';
-
-create function month(date)
- returns int4
- as '$func'
- language 'c';
-
-create function year(date)
- returns int4
- as '$func'
- language 'c';
-
-create function asminutes(time)
- returns int4
- as '$func'
- language 'c';
-
-create function asseconds(time)
- returns int4
- as '$func'
- language 'c';
-
-create operator - (
- leftarg=time,
- rightarg=time,
- procedure=time_difference);
-%